{{ curDB.name }} object type support

In DbVisualizer

The following table shows the database specific support in DbVisualizer Pro 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
Catalogs
Create Database Catalogs
Catalog
Drop Database, Rename Database References, Tables
Schemas
Create Schema Schemas
Schema
Export Schema, Drop Schema References, Tables
Tables
Create Table, Import Table Data References, Tables
Table
Alter Table, Export Table, Import Table Data, Drop Table, Empty Table, Rename Table, Script: Script Table Navigator1, References, Data, Columns, DDL, Grants, Info, Primary Key, Row Count
Columns
  Columns
Column
  Column
Views
  Views
View
Export View, Drop View, Rename View, Script: Script View Columns, DDL, Data, Info, Row Count
Columns
  Columns
Column
  Column
Sequences
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence Info
Procedures
Create Procedure Procedures
Procedure
Export Procedure, Comment Procedure, Drop Procedure, Rename Procedure, Script: Script Procedure Procedure Editor, Interface
Functions
Create Function Functions
Function
Export Function, Comment Function, Drop Function, Rename Function, Script: Script Function Function Editor, Interface
ExternalTables
  External Tables
ExternalTable
  External Tables
MaterializedViews
  Materialized Views
MaterializedView
Drop Materialized View, Script: Script Materialized View Data, Columns, Info, Row Count
FileFormats
  FileFormats
FileFormat
  FileFormat
Stages
  Stages
Stage
  Stage
Pipes
  Pipes
Pipe
  Pipe
DBA
  DBA
ServerInfo
  Parameters
Users
Create User2 Users, Users2
User2
Abort all queries, Disable/Enable User, Drop User, Rename User Describe, Info, Last Queries, Login Attempts
Roles
Create Role2 Enabled Roles, Roles
Role
Drop Role2 Info, Role grants
Warehouses
Create Warehouse Metering history 10 days, Warehouses
Warehouse
Drop Warehouse, Resume/Suspend Info
Locks
  Locks
QueryHistory
  Last Queries
1) DbVisualizer Pro
2) Requires the SECURITY_ADMIN role