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
ConstraintColumn
   Info
DistKeyColumns
    
DistKeyColumn
    
SortKeyColumns
    
SortKeyColumn
    
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
MaterializedViews
   Materialized Views
MaterializedView
 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
ExternalSchemas
   External Schemas
ExternalSchema
    
ExternalTables
   External Tables
ExternalTable
 Drop External Table Data, Columns, Info, Row Count
ExternalColumns
    
ExternalColumn
    
DBA
   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
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗