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], Comment Table, Create Index, Drop Table, Empty Table, Rename Table, Script: Script 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
|
|
|
TableIndexes
|
|
|
Indexes
|
|
|
Index
|
|
Comment Index, Drop Index, Rename Index, Script: Script Index
|
DDL[1], Index
|
|
|
TableTriggers
|
|
|
Triggers
|
|
|
Trigger
|
|
Export Trigger[1], Comment Trigger, Drop Trigger
|
Trigger Editor[1], Info, Source
|
|
|
Views
|
|
|
Views
|
|
|
View
|
|
Create Trigger, Export View[1], Comment View, Drop View, Script: Script View
|
Data, Columns, DDL[1], Grants, Info, Row Count, Triggers
|
|
|
Columns
|
|
|
Columns
|
|
|
Column
|
|
Comment Column
|
Column
|
|
|
TableTriggers
|
|
|
Triggers
|
|
|
Trigger
|
|
Export Trigger[1], Comment Trigger, Drop Trigger
|
Trigger Editor[1], Info, Source
|
|
|
TemporaryTables
|
|
|
Temporary Tables
|
|
|
TemporaryTable
|
|
Drop Table, Script: Script Table
|
Columns, Info
|
|
|
Aliases
|
|
Create Alias
|
Aliases
|
|
|
Alias
|
|
Comment Alias, Drop Alias, Script: Script Alias
|
Info
|
|
|
Nicknames
|
|
|
Nicknames
|
|
|
Nickname
|
|
Comment Nickname, Drop Nickname, Script: Script Nickname
|
Data, Columns, Info, Row Count
|
|
|
Indexes
|
|
|
Indexes
|
|
|
Index
|
|
Comment Index, Drop Index, Rename Index, Script: Script Index
|
DDL[1], Index
|
|
|
Sequences
|
|
Create Sequence
|
Sequences
|
|
|
Sequence
|
|
Comment Sequence, Drop Sequence
|
Grants, Info
|
|
|
SystemTables
|
|
|
SYSCAT, SYSFUN, SYSIBM, SYSSTAT
|
|
|
MaterializedQueryTables
|
|
|
Materialized Query Tables
|
|
|
MaterializedQueryTable
|
|
Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table, Script: Script Materialized Query Table
|
Data, Columns, Indexes, Info, Row Count, Source
|
|
|
TableIndexes
|
|
|
Indexes
|
|
|
Index
|
|
Comment Index, Drop Index, Rename Index, Script: Script Index
|
DDL[1], Index
|
|
|
Functions
|
|
Create Function
|
Functions
|
|
|
Function
|
|
Export Function[1], Comment Function, Drop Function, Script: Script Function
|
Function Editor[1], Info, Parameters, Result
|
|
|
Procedures
|
|
Create Procedure
|
Stored Procedures
|
|
|
Procedure
|
|
Export Procedure[1], Comment Procedure, Drop Procedure, Script: Script Procedure
|
Procedure Editor[1], Info, Interface
|
|
|
DB2Packages
|
|
|
Packages
|
|
|
DB2Package
|
|
Drop Package
|
Info
|
|
|
Triggers
|
|
|
Triggers
|
|
|
Trigger
|
|
Export Trigger[1], Comment Trigger, Drop Trigger
|
Trigger Editor[1], Info, Source
|
|
|
DBA
|
|
|
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
|
|
|
Tablespaces
|
|
|
Table Spaces
|
[1]
DbVisualizer Pro
[2]
Version 9.5 and later
[3]
Version 8.0 to 9.6
|