Vertica
The following table shows the database specific support in DbVisualizer for Vertica organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
Schemas | Create Schema | Schemas |
Schema | Export Schema[1], Analyze Workload For Schema[2], Drop Schema, Rename Schema | References, Tables |
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 Stats for Table, Analyze Workload For Table[2], Change Table Owner, Drop Table, Empty Table, Move Table to Schema, Purge Table, Refresh Projections, Remove Partitioning, Rename Table, Reorganize Table | Navigator[1], References, Data, Columns, Constraints, DDL, Grants, Info, Primary Key, Projection Storage, Row Count |
Columns | Columns | |
Column | Analyze Stats for Column | Column, Statistics |
Projections containing Column | Projections | |
Projection | Script: Script Projection, Drop Projection, Rename Projection | Data, Columns, DDL, Partitions, Storage, Storage Containers |
Projections | Projections | |
Projection | Script: Script Projection, Drop Projection, Rename Projection | Data, Columns, DDL, Partitions, Storage, Storage Containers |
Global Temp Tables | Create Table[1], Import Table Data[1] | Tables |
Temp Table | Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Analyze Stats for Table, Analyze Workload For Table[2], Drop Table, Empty Table, Refresh Projection, Rename Table | Data, Columns, DDL, Row Count |
Columns | Columns | |
Column | Analyze Stats for Column | Column, Statistics |
Flex Tables[3] | Create Flex Table[1] | Tables |
Flex Table | Alter Flex Table[1], Script: Script Table, Analyze Stats for Table, Analyze Workload For Table[2], Build View, Compute and Build View, Copy From, Drop Table, Empty Table, Refresh Projection, Rename Table | Data, Columns, DDL, Map to String, Row Count |
Columns | Columns | |
Column | Analyze Stats for Column | Column, Statistics |
Views | Views | |
View | Script: Script Table, Drop View, Rename View | Navigator[1], References, Data, Columns, Constraints, DDL, Row Count |
Columns | Columns | |
Column | Analyze Stats for Column | Column, Statistics |
Projections | Activity, Projections, Refreshes, Storage | |
Projection | Script: Script Projection, Drop Projection, Rename Projection | Data, Columns, DDL, Partitions, Storage, Storage Containers |
Sequences | Create Sequence | Sequences |
Sequence | Script: Script Sequence, Drop Sequence, Rename Sequence | Info |
Functions (SQL) | Create Function | Functions |
Function | Export Function[1], Script: Script Function, Drop Function, Rename Function | Function Editor[1], Info |
Procedures | Create External Procedure, Create Stored Procedure | Procedures |
Procedure | Export Procedure[1], Script: Script Procedure, Drop Procedure | Procedure Editor[1] |
Libraries | Create Library[2] | Libraries |
Library | Drop Library[2], Set Library Filename[2] | Info |
Factory Functions | Factory Functions | |
Factory Function | Info | |
UDFs | User Defined Extensions | |
Aggregates | Create Aggregate Function | Aggregates |
UDXAggregate | Drop Aggregate Function | Info |
Analytics | Create Analytic Function | Analytics |
UDXAnalytic | Info | |
Filters | Create Filter Function[2] | Filters |
UDXFilter | Drop Filter Function[2] | Info |
Functions | Create Function (UDF) | Functions |
UDXFunction | Drop Function (UDF) | Info |
Parsers | Create Parser Function[2] | Parsers |
UDXParser | Drop Parser Function[2] | Info |
Sources | Create Source Function[2] | Sources |
UDXSource | Drop Source Function[2] | Info |
Transforms | Create Transform Function | Transforms |
UDXTransform | Drop Transform Function | Info |
Other | Other | |
UDXOther | Info | |
System Schemas | ||
System Schema | ||
System Tables | Tables | |
System Table | Data | |
Columns | Columns | |
Column | Analyze Stats for Column | Column, Statistics |
Local Temp Tables | Create Table[4][1], Import Table Data[1] | Tables |
Temp Table | Alter Table[1], Export Table[1], Import Table Data[1], Script: Script Table, Analyze Stats for Table, Analyze Workload For Table[2], Drop Table, Empty Table, Refresh Projection, Rename Table | Data, Columns, DDL, Row Count |
Columns | Columns | |
Column | Analyze Stats for Column | Column, Statistics |
DBA Views | DBA | |
Databases | Databases | |
Database | Analyze Stats for Database, Analyze Workload For Database[2], Export Statistics[2], Refresh Projections | Info |
Users | Create User[2] | Users |
User | Alter User[2], Change Password, Drop User[2] | Info, Passwords |
Roles | Create Role[2] | Roles |
Role | Drop Role[2], Rename Role[2] | |
User | Alter User[2], Change Password, Drop User[2] | Info, Passwords |
Profiles | Create Profile[2] | Profiles |
Profile | Alter Profile[2], Drop Profile[2] | Info |
User | Alter User[2], Change Password, Drop User[2] | Info, Passwords |
Recent Queries | Long Queries, Recent Queries | |
System | Session Settings, System, System Settings | |
Locks | Locks | |
Sessions | Sessions | |
Session | Close Session[2] | Info |
Licenses | Audit License Size[2], Audit License Term[2] | License Audits, License Compliance, Licenses |
Load Streams | Load Streams | |
Tuple Mover Operations | Run Tuple Mover on Projection[2], Run Tuple Mover on Table[2] | Tuple Mover Operations |
Tuning Recommendations | Tuning Recommendations | |
Nodes | Nodes | |
Node | Disk Resource Rejections, Disk Storage, Host Resources, Info, Node Resource Usage, Node Resources | |
Resource Pools | Resource Pools | |
Scheduler Job | Info, Queues, Rejections, Status | |
|
[1]
DbVisualizer Pro
[2] Must be superuser [3] Version 7 and later [4] Single Physical Connection must be enabled | ||