{{ 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], 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