redshift
Redshift Tested for version 1.0.7804+
Overview JDBC Drivers Features Supported Objects Download

Redshift

Redshift object type support.

The following table shows the database specific support in DbVisualizer for Redshift 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
Databases
 Create Database Databases
Catalog
 Drop Database References, Tables
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Comment Schema, Drop Schema, Rename Schema Info
Tables
 Create Table[1], Import Table Data[1] References, Tables
Table
 Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Analyze Table, Comment Table, Drop Table, Empty Table, Rename Table, Vacuum Table References, Data, Columns, DDL[1], Grants, Info, Primary Key, Row Count, Row Id
Columns
   Columns
Column
 Comment Column Column
Constraints
   Constraints
Constraint
 Drop Constraint Columns, DDL, Info
Constraint Column
   Info
DistKey
    
Dist Key Column
    
SortKey
    
Sort Key Column
    
Views
   Views
View
 Export View[1], Script: Script View, Comment View, Drop View, Rename View Data, Columns, DDL[1], Grants, Info, Row Count
Columns
   Columns
Column
 Comment Column Column
Materialized Views
   Materialized Views
Materialized View
 Script: Script Materialized View, Comment Materialized View, Drop Materialized View, Refresh Materialized View Data, Columns, DDL, Grants, Info, Row Count
Columns
   Columns
Column
 Comment Column Column
Functions
 Create Function Functions
Function
 Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function Function Editor[1], Info
Procedures[2]
 Create Procedure Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure, Rename Procedure Procedure Editor[1], Info
Domains
   Domains
Domain
 Drop Domain Info
Aggregates
   Aggregates
Aggregate
 Drop Aggregate, Rename Aggregate Info
Operators
   Operators
Operator
   Info
Types
   Types
Type
 Comment Type, Drop Type Info
External Schemas
   External Schemas
External Schema
    
External Tables
   External Tables
External Table
 Drop External Table Data, Columns, Info, Row Count
Columns
    
External Column
    
DBA Views
   DBA
Users
 Create User Users
User
 Drop User Info
Groups
 Create Group Groups
Group
 Drop Group Info
Settings
   Settings
Locks
   Locks
Sessions
   Sessions
Session
 Cancel Session, Terminate Session Current Query, Session
[1] DbVisualizer Pro
[2] Version 1.0.7287 and later