Redshift
The following table shows the database specific support in DbVisualizer for Redshift organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
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 | ||