Vertica
Vertica Tested for version 6.1.3+
Overview JDBC Drivers Features Supported Objects Download

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
Image Image Schemas
 Create Schema Schemas
Image Image Schema
 Export Schema[1], Analyze Workload For Schema[2], Drop Schema, Rename Schema References, Tables
Image Image Tables
 Create Table[1], Import Table Data[1] References, Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
 Analyze Stats for Column Column, Statistics
Image Image Projections containing Column
   Projections
Image Image Projection
 Script: Script Projection, Drop Projection, Rename Projection Data, Columns, DDL, Partitions, Storage, Storage Containers
Image Image Projections
   Projections
Image Image Projection
 Script: Script Projection, Drop Projection, Rename Projection Data, Columns, DDL, Partitions, Storage, Storage Containers
Image Image Global Temp Tables
 Create Table[1], Import Table Data[1] Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
 Analyze Stats for Column Column, Statistics
Image Image Flex Tables[3]
 Create Flex Table[1] Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
 Analyze Stats for Column Column, Statistics
Image Image Views
   Views
Image Image View
 Script: Script Table, Drop View, Rename View Navigator[1], References, Data, Columns, Constraints, DDL, Row Count
Image Image Columns
   Columns
Image Image Column
 Analyze Stats for Column Column, Statistics
Image Image Projections
   Activity, Projections, Refreshes, Storage
Image Image Projection
 Script: Script Projection, Drop Projection, Rename Projection Data, Columns, DDL, Partitions, Storage, Storage Containers
Image Image Sequences
 Create Sequence Sequences
Image Image Sequence
 Script: Script Sequence, Drop Sequence, Rename Sequence Info
Image Image Functions (SQL)
 Create Function Functions
Image Image Function
 Export Function[1], Script: Script Function, Drop Function, Rename Function Function Editor[1], Info
Image Image Procedures
 Create External Procedure, Create Stored Procedure Procedures
Image Image Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1]
Image Image Libraries
 Create Library[2] Libraries
Image Image Library
 Drop Library[2], Set Library Filename[2] Info
Image Image Factory Functions
   Factory Functions
Image Image Factory Function
   Info
Image Image UDFs
   User Defined Extensions
Image Image Aggregates
 Create Aggregate Function Aggregates
Image Image UDXAggregate
 Drop Aggregate Function Info
Image Image Analytics
 Create Analytic Function Analytics
Image Image UDXAnalytic
   Info
Image Image Filters
 Create Filter Function[2] Filters
Image Image UDXFilter
 Drop Filter Function[2] Info
Image Image Functions
 Create Function (UDF) Functions
Image Image UDXFunction
 Drop Function (UDF) Info
Image Image Parsers
 Create Parser Function[2] Parsers
Image Image UDXParser
 Drop Parser Function[2] Info
Image Image Sources
 Create Source Function[2] Sources
Image Image UDXSource
 Drop Source Function[2] Info
Image Image Transforms
 Create Transform Function Transforms
Image Image UDXTransform
 Drop Transform Function Info
Image Image Other
   Other
Image Image UDXOther
   Info
Image Image System Schemas
    
Image Image System Schema
    
Image Image System Tables
   Tables
Image Image System Table
   Data
Image Image Columns
   Columns
Image Image Column
 Analyze Stats for Column Column, Statistics
Image Image Local Temp Tables
 Create Table[4][1], Import Table Data[1] Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
 Analyze Stats for Column Column, Statistics
Image Image DBA Views
   DBA
Image Image Databases
   Databases
Image Image Database
 Analyze Stats for Database, Analyze Workload For Database[2], Export Statistics[2], Refresh Projections Info
Image Image Users
 Create User[2] Users
Image Image User
 Alter User[2], Change Password, Drop User[2] Info, Passwords
Image Image Roles
 Create Role[2] Roles
Image Image Role
 Drop Role[2], Rename Role[2]  
Image Image User
 Alter User[2], Change Password, Drop User[2] Info, Passwords
Image Image Profiles
 Create Profile[2] Profiles
Image Image Profile
 Alter Profile[2], Drop Profile[2] Info
Image Image User
 Alter User[2], Change Password, Drop User[2] Info, Passwords
Image Image Recent Queries
   Long Queries, Recent Queries
Image Image System
   Session Settings, System, System Settings
Image Image Locks
   Locks
Image Image Sessions
   Sessions
Image Image Session
 Close Session[2] Info
Image Image Licenses
 Audit License Size[2], Audit License Term[2] License Audits, License Compliance, Licenses
Image Image Load Streams
   Load Streams
Image Image Tuple Mover Operations
 Run Tuple Mover on Projection[2], Run Tuple Mover on Table[2] Tuple Mover Operations
Image Image Tuning Recommendations
   Tuning Recommendations
Image Image Nodes
   Nodes
Image Image Node
   Disk Resource Rejections, Disk Storage, Host Resources, Info, Node Resource Usage, Node Resources
Image Image Resource Pools
   Resource Pools
Image Image 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