IBM Db2 on Cloud
The following table shows the database specific support in DbVisualizer for IBM Db2 on Cloud organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
Schemas | Create Schema | Schemas |
Schema | Export Schema[1], Comment Schema, Drop Schema | References, Tables |
Tables | Create Table[1], Import Table Data[1] | References, Tables |
Table | Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Comment Table, Create Index, Drop Table, Empty Table, Rename Table | Navigator[1], References, Data, Columns, Constraints, DDL[1], Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers |
Columns | Columns | |
Column | Comment Column | Column |
Indexes | Indexes | |
Index | Script: Script Index, Comment Index, Drop Index, Rename Index | DDL[1], Index |
Triggers | Triggers | |
Trigger | Export Trigger[1], Comment Trigger, Drop Trigger | Trigger Editor[1], Info, Source |
Views | Views | |
View | Create Trigger, Export View[1], Script: Script View, Comment View, Drop View | Data, Columns, DDL[1], Grants, Info, Row Count, Triggers |
Columns | Columns | |
Column | Comment Column | Column |
Triggers | Triggers | |
Trigger | Export Trigger[1], Comment Trigger, Drop Trigger | Trigger Editor[1], Info, Source |
Temporary Tables | Temporary Tables | |
Temporary Table | Script: Script Table, Drop Table | Columns, Info |
Aliases | Create Alias | Aliases |
Alias | Script: Script Alias, Comment Alias, Drop Alias | Info |
Nicknames | Nicknames | |
Nickname | Script: Script Nickname, Comment Nickname, Drop Nickname | Data, Columns, Info, Row Count |
Indexes | Indexes | |
Index | Script: Script Index, Comment Index, Drop Index, Rename Index | DDL[1], Index |
Sequences | Create Sequence | Sequences |
Sequence | Comment Sequence, Drop Sequence | Grants, Info |
System Tables | SYSCAT, SYSFUN, SYSIBM, SYSSTAT | |
Materialized Query Tables | Materialized Query Tables | |
Materialized Query Table | Script: Script Materialized Query Table, Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table | Data, Columns, Indexes, Info, Row Count, Source |
Indexes | Indexes | |
Index | Script: Script Index, Comment Index, Drop Index, Rename Index | DDL[1], Index |
Functions | Create Function | Functions |
Function | Export Function[1], Script: Script Function, Comment Function, Drop Function | Function Editor[1], Info, Parameters, Result |
Stored Procedures | Create Procedure | Stored Procedures |
Procedure | Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure | Procedure Editor[1], Info, Interface |
Packages | Packages | |
DB2 Package | Drop Package | Info |
Triggers | Triggers | |
Trigger | Export Trigger[1], Comment Trigger, Drop Trigger | Trigger Editor[1], Info, Source |
DBA Views | DBA | |
Users | Users | |
User | Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Roles, Schema Privilege, Table Privilege | |
Groups | Roles | |
Group | Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Roles, Schema Privilege, Table Privilege | |
Roles[2] | Create Role | Roles |
Role | Drop Role | Column Privilege, Groups, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege, Users |
Locks[3] | Locks | |
Table Spaces | Table Spaces | |
|
[1]
DbVisualizer Pro
[2] Version 9.5 and later [3] Version 8.0 to 9.6 | ||