Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
(1) I created a Netezza server with schema grouping turned on (Server Properties -> Advanced -> Schema Folder Grouping -> Yes) (see attachment-1).
(2) I then right click a schema node and select 'Create Schema' to get the 'Create Schema' dialog displayed (see attachment-2).
(3) I filled out the "Name" field and click the "Preview SQL" tab, it shows "CREATE SCHEMA name" (see attachment-3).
(4) I click the "Create" button. The schema defined in step (3) is not displayed under the active database node.
(5) I refreshed the "Databases" node, the schema defined in step (3) is displayed as a child database node under the Databases node (see attachment-4).
(6) I then opened a Query Analyzer, execute a 'drop database' DDL and was able to drop the newly displayed database node (see attachment-5).
Is this a known problem?
|
|
12 KB
|
|
9 KB
|
|
40 KB
|
|
38 KB
|
|
20 KB
Create schema is an alias for create database in netezza. I am not sure why they have this as its not documented in any of there docs. Aquaclusters Issue# 4993 was filed for version 9.x and we removed the create schema from the menus for netezza. I think the menus work different when we group by schema in the connection, but we shouldn't be using the create schema command as I believe it may get implemented in the future and do something other then what it does right now.
Removed the schema commands from the menus as the list of schemas is actually users and 'create schema' DDL command is not truly supported by Netezza. Verified in 14.0-dev-20
Removed the schema commands from the menus as the list of schemas is actually users and 'create schema' DDL command is not truly supported by Netezza. Verified in 14.0-dev-20
Issue #8224 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
relates to #4993
Issue #4993Create Schema in Netezza |
Create schema is an alias for create database in netezza. I am not sure why they have this as its not documented in any of there docs. Aquaclusters Issue# 4993 was filed for version 9.x and we removed the create schema from the menus for netezza. I think the menus work different when we group by schema in the connection, but we shouldn't be using the create schema command as I believe it may get implemented in the future and do something other then what it does right now.