Db2

Db2 object type support.

The following table shows the database specific support in DbVisualizer for Db2 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 TypeActionsViewers
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
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗