Redshift
Redshift object type support.
The following table shows the database specific support in DbVisualizer for Redshift organized per database object type.
Redshift
The following table shows the database specific support in DbVisualizer for Redshift organized per database object type.
Object Type | Actions | Viewers | |||
---|---|---|---|---|---|
| Create Database | Databases | |||
| Drop Database | References, Tables | |||
| Create Schema | Schemas | |||
| Export Schema[1], Comment Schema, Drop Schema, Rename Schema | Info | |||
| Create Table[1], Import Table Data[1] | References, Tables | |||
| 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 | ||||
| Comment Column | Column | |||
| |||||
| |||||
| |||||
| |||||
| Views | ||||
| Export View[1], Script: Script View, Comment View, Drop View, Rename View | Data, Columns, DDL[1], Grants, Info, Row Count | |||
| Columns | ||||
| Comment Column | Column | |||
| Create Function | Functions | |||
| Export Function[1], Script: Script Function, Comment Function, Drop Function, Rename Function | Function Editor[1], Info | |||
| Create Procedure | Procedures | |||
| Export Procedure[1], Script: Script Procedure, Drop Procedure, Rename Procedure | Procedure Editor[1], Info | |||
| Domains | ||||
| Drop Domain | Info | |||
| Aggregates | ||||
| Drop Aggregate, Rename Aggregate | Info | |||
| Operators | ||||
| Info | ||||
| Types | ||||
| Comment Type, Drop Type | Info | |||
| External Schemas | ||||
| |||||
| External Tables | ||||
| Drop External Table | Data, Columns, Info, Row Count | |||
| |||||
| |||||
| DBA | ||||
| Create User | Users | |||
| Drop User | Info | |||
| Create Group | Groups | |||
| Drop Group | Info | |||
| Settings | ||||
| Locks | ||||
| Sessions | ||||
| Cancel Session, Terminate Session | Current Query, Session | |||
[1]
DbVisualizer Pro
[2] Version 1.0.7287 and later |