Vertica

Vertica object type support.

The following table shows the database specific support in DbVisualizer for Vertica 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
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