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
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
ProjectionsTable
   Projections
Projection
 Script: Script Projection, Drop Projection, Rename Projection Data, Columns, DDL, Partitions, Storage, Storage Containers
ProjectionsTable
   Projections
Projection
 Script: Script Projection, Drop Projection, Rename Projection Data, Columns, DDL, Partitions, Storage, Storage Containers
GlobalTempTables
 Create Table[1], Import Table Data[1] Tables
TempTable
 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
FlexTables[3]
 Create Flex Table[1] Tables
FlexTable
 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
ProjectionsSchema
   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
 Create Function Functions
Function
 Export Function[1], Script: Script Function, Drop Function, Rename Function Function Editor[1], Info
Libraries
 Create Library[2] Libraries
Library
 Drop Library[2], Set Library Filename[2] Info
FactoryFunctions
   Factory Functions
FactoryFunction
   Info
UDX
   User Defined Extensions
UDXAggregates
 Create Aggregate Function Aggregates
UDXAggregate
 Drop Aggregate Function Info
UDXAnalytics
 Create Analytic Function Analytics
UDXAnalytic
   Info
UDXFilters
 Create Filter Function[2] Filters
UDXFilter
 Drop Filter Function[2] Info
UDXFunctions
 Create Function (UDF) Functions
UDXFunction
 Drop Function (UDF) Info
UDXParsers
 Create Parser Function[2] Parsers
UDXParser
 Drop Parser Function[2] Info
UDXSources
 Create Source Function[2] Sources
UDXSource
 Drop Source Function[2] Info
UDXTransforms
 Create Transform Function Transforms
UDXTransform
 Drop Transform Function Info
UDXOthers
   Other
UDXOther
   Info
Procedures
 Create Procedure Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1]
SystemSchemas
    
SystemSchema
    
SystemTables
   Tables
SystemTable
   Data
Columns
   Columns
Column
 Analyze Stats for Column Column, Statistics
LocalTempTables
 Create Table[4][1], Import Table Data[1] Tables
TempTable
 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
   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
RecentQueries
   Long Queries, Recent Queries
System
   Session Settings, System, System Settings
Locks
   Locks
Sessions
   Sessions
Session
 Close Session[2] Info
License
 Audit License Size[2], Audit License Term[2] License Audits, License Compliance, Licenses
Streams
   Load Streams
TupleMover
 Run Tuple Mover on Projection[2], Run Tuple Mover on Table[2] Tuple Mover Operations
TuningRecommendations
   Tuning Recommendations
Nodes
   Nodes
Node
   Disk Resource Rejections, Disk Storage, Host Resources, Info, Node Resource Usage, Node Resources
SchedulerJobs
   Resource Pools
SchedulerJob
   Info, Queues, Rejections, Status
[1] DbVisualizer Pro
[2] Must be superuser
[3] Version 7 and later
[4] Single Physical Connection must be enabled
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗