IBM Db2 on Cloud
IBM Db2 Cloud
Overview JDBC Drivers Features Supported Objects Download

IBM Db2 on Cloud

IBM Db2 on Cloud object type support.

The following table shows the database specific support in DbVisualizer for IBM Db2 on Cloud 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
Image Image Schemas
 Create Schema Schemas
Image Image Schema
 Export Schema[1], Comment Schema, Drop Schema References, Tables
Image Image Tables
 Create Table[1], Import Table Data[1] References, Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rename Index DDL[1], Index
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Comment Trigger, Drop Trigger Trigger Editor[1], Info, Source
Image Image Views
   Views
Image Image View
 Create Trigger, Export View[1], Script: Script View, Comment View, Drop View Data, Columns, DDL[1], Grants, Info, Row Count, Triggers
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Comment Trigger, Drop Trigger Trigger Editor[1], Info, Source
Image Image Temporary Tables
   Temporary Tables
Image Image Temporary Table
 Script: Script Table, Drop Table Columns, Info
Image Image Aliases
 Create Alias Aliases
Image Image Alias
 Script: Script Alias, Comment Alias, Drop Alias Info
Image Image Nicknames
   Nicknames
Image Image Nickname
 Script: Script Nickname, Comment Nickname, Drop Nickname Data, Columns, Info, Row Count
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rename Index DDL[1], Index
Image Image Sequences
 Create Sequence Sequences
Image Image Sequence
 Comment Sequence, Drop Sequence Grants, Info
Image Image System Tables
   SYSCAT, SYSFUN, SYSIBM, SYSSTAT
Image Image Materialized Query Tables
   Materialized Query Tables
Image Image Materialized Query Table
 Script: Script Materialized Query Table, Comment Materialized Query Table, Drop Materialized Query Table, Refresh Materialized Query Table Data, Columns, Indexes, Info, Row Count, Source
Image Image Indexes
   Indexes
Image Image Index
 Script: Script Index, Comment Index, Drop Index, Rename Index DDL[1], Index
Image Image Functions
 Create Function Functions
Image Image Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function Function Editor[1], Info, Parameters, Result
Image Image Stored Procedures
 Create Procedure Stored Procedures
Image Image Procedure
 Export Procedure[1], Script: Script Procedure, Comment Procedure, Drop Procedure Procedure Editor[1], Info, Interface
Image Image Packages
   Packages
Image Image DB2 Package
 Drop Package Info
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Comment Trigger, Drop Trigger Trigger Editor[1], Info, Source
Image Image DBA Views
   DBA
Image Image Users
   Users
Image Image User
   Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Roles, Schema Privilege, Table Privilege
Image Image Groups
   Roles
Image Image Group
   Column Privilege, Index Privilege, Info, Package Privilege, Passthru Privilege, Roles, Schema Privilege, Table Privilege
Image Image Roles[2]
 Create Role Roles
Image Image Role
 Drop Role Column Privilege, Groups, Index Privilege, Info, Package Privilege, Passthru Privilege, Schema Privilege, Table Privilege, Users
Image Image Locks[3]
   Locks
Image Image Table Spaces
   Table Spaces
[1] DbVisualizer Pro
[2] Version 9.5 and later
[3] Version 8.0 to 9.6