{{ curDB.name }} object type support

• Object type support
• Driver info
• Features

Back to {{ curDB.name }}

The following table shows the database specific support in DbVisualizer for {{ curDB.name }} organized per database object type.

• Object Type - show what object types are listed in the Databases tab
• Actions - show what actions are available for the object type
• Viewers - show what viewers are available for the 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
TableIndexes		Indexes
Index	Script: Script Index, Comment Index, Drop Index, Rename 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], Script: Script View, Comment View, Drop 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	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
SystemTables		SYSCAT, SYSFUN, SYSIBM, SYSSTAT
MaterializedQueryTables		Materialized Query Tables
MaterializedQueryTable	Script: Script Materialized Query Table, Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table	Data, Columns, Indexes, Info, Row Count, Source
TableIndexes		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
Procedures	Create Procedure	Stored Procedures
Procedure	Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop 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