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