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