{{ curDB.name }} object type support

• Object type support
• Driver info
• Features

Back to {{ curDB.name }}

The following table shows the database specific support in DbVisualizer for {{ curDB.name }} 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 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
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