Database specific support for DB2 LUWDatabase specific support for DB2 LUW

The following table show the database specific support for Database specific support for DB2 LUW 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, Comment Schema, Drop Schema  
Tables
Create Table, Import Table Data References, Tables
Table
Alter Table, Create Trigger, Export Table, Import Table Data, Comment Table, Create Index, Drop Table, Empty Table, Rename Table, Script: Script Table Navigator1, References, Columns, Constraints, DDL, Data, 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, Index
TableTriggers
  Triggers
Trigger
Export Trigger, Comment Trigger, Drop Trigger Trigger Editor, Info, Source
Views
  Views
View
Create Trigger, Export View, Comment View, Drop View, Script: Script View Columns, DDL, Data, Grants, Info, Row Count, Triggers
Columns
  Columns
Column
Comment Column Column
TableTriggers
  Triggers
Trigger
Export Trigger, Comment Trigger, Drop Trigger Trigger Editor, 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 Columns, Data, Info, Row Count
Nicknames
  Nicknames
Nickname
Comment Nickname, Drop Nickname, Script: Script Nickname Columns, Data, Info, Row Count
Indexes
  Indexes
Index
Comment Index, Drop Index, Rename Index, Script: Script Index DDL, 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 Columns, Data, Indexes, Info, Row Count, Source
TableIndexes
  Indexes
Index
Comment Index, Drop Index, Rename Index, Script: Script Index DDL, Index
Functions
Create Function Functions
Function
Export Function, Comment Function, Drop Function, Script: Script Function Function Editor, Info, Parameters, Result
Procedures
Create Procedure Stored Procedures
Procedure
Export Procedure, Comment Procedure, Drop Procedure, Script: Script Procedure Procedure Editor, Info, Interface
DB2Packages
  Packages
DB2Package
Drop Package Info
Triggers
  Triggers
Trigger
Export Trigger, Comment Trigger, Drop Trigger Trigger Editor, Info, Source
DBA
  DBA
Users
  Users
User
  Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege
Groups
  Roles
Group
  Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege
Roles2
Create Role Roles
Role
Drop Role Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege
Locks3
  Locks
Tablespaces
  Table Spaces
1) DbVisualizer Pro
2) Version 9.5 and later
3) Version 8.0 to 9.6