Netezza
The following table shows the database specific support in DbVisualizer for Netezza organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
Databases | Create Database | Catalogs |
Catalog | References, Tables | |
Schemas | Create Schema[1] | Schemas |
Schema | Export Schema[2], Drop Schema, Rename Schema | References, Tables |
Tables | Create Table[2], Import Table Data[2] | References, Tables |
Table | Alter Table[2], Export Table[2], Import Table Data[2], Script: Script Table, Drop Table, Empty Table, Generate Statistics, Groom Table | Navigator[2], References, Data, Columns, DDL[2], Info, Primary Key, Row Count, Row Id |
Columns | Columns | |
Column | Column | |
Views | Views | |
View | Export View[2], Script: Script View, Drop View | Data, DDL[2], Info, Row Count |
Columns | Columns | |
Column | Column | |
Materialized Views | Views | |
Materialized View | Drop Materialized View | Data, Info, Row Count, Select SQL |
Columns | Columns | |
Column | Column | |
Sequences | Create Sequence | Sequences |
Sequence | Drop Sequence | Info |
Synonyms | Synonyms | |
Synonym | Drop Synonym | Info |
Functions | Functions | |
Function | Info | |
Procedures | Create Procedure | Procedures |
Procedure | Export Procedure[2], Script: Script Procedure, Drop Procedure | Procedure Editor[2], Info |
DBA Views | DBA | |
Users | Create User | Users |
User | Drop User | Info |
Groups | Create Group | Groups |
Group | Drop Group | Info |
|
[1]
If multiple schemas support is enabled
[2] DbVisualizer Pro | ||