{{ 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
Locks[1]		Mimer SQL Auto
Statements[2]	Call, Delete, Insert, Select, Set, Update
Statement	Comment Statement, Drop Statement, Execute Statement, Execute Statement[3], Grant Execute, Refresh Statement, Revoke Execute
Schemas	Create Schema	Schema Facts, Schemas
Schema	Export Schema[4], Comment Schema, Drop Schema	Comments, Info
Tables	Create Table[4], Import Table Data[4], Create Table[5], Update Statistics	References, Table Facts, Tables
Table	Alter Table[4], Create Trigger, Import Table Data[4], Script: Script Table, Add Check, Add Column, Add Foreign Key, Add Primary/Unique Key, Comment Table, Create Index, Drop Column, Drop Constraint, Drop Index, Drop Table, Empty Table[6], Export Table[4], Grant Access, Revoke Access, Update Statistics	Navigator[4], References, Data, Access Rights, Comments, DDL[4], DDL[5], Indexes, Info, Primary Key, Row Count, Subscriptions, Table used by, Table uses, Usage[4]
Columns		Columns
Column	Comment Column, Create Index, Data Type, Drop Column, Drop Default, Grant Column Access, Revoke Column Access, Set Default	Column, Column Privileges, Column used by, Column uses
Constraints	Add Check, Add Foreign Key, Add Primary/Unique Key	Constraints
Constraint	Drop Constraint	Constraint, DDL
Column	Comment Column, Create Index, Data Type, Drop Column, Drop Default, Grant Column Access, Revoke Column Access, Set Default	Column, Column Privileges, Column used by, Column uses
Indexes		Index Facts, Indexes
Index	Comment Index, Drop Index	Columns, DDL
Column	Comment Column, Create Index, Data Type, Drop Column, Drop Default, Grant Column Access, Revoke Column Access, Set Default	Column, Column Privileges, Column used by, Column uses
Triggers	Create Table Trigger, Create View Trigger	Trigger Facts, Triggers
Trigger	Export Trigger[4], Comment Trigger, Drop Trigger	Trigger Editor[4], DDL[5], Info, Trigger uses
AccessPaths[7]		Access Paths
AccessPath	Drop Access Path	Access Path, Columns
AccessPathColumn		Column
Views	Script: Create View	View Facts, Views
View	Export View[4], Script: Script View, Comment View, Create Trigger, Drop View, Grant Access, Revoke Access	Data, Access Rights, Comments, DDL, Info, References, Row Count, View used by, View uses
Columns		Columns
ViewColumn	Comment Column, Grant Column Access, Revoke Column Access	Column, Column Privileges, Column used by, Column uses
Triggers	Create Table Trigger, Create View Trigger	Trigger Facts, Triggers
Trigger	Export Trigger[4], Comment Trigger, Drop Trigger	Trigger Editor[4], DDL[5], Info, Trigger uses
Triggers	Create Table Trigger, Create View Trigger	Trigger Facts, Triggers
Trigger	Export Trigger[4], Comment Trigger, Drop Trigger	Trigger Editor[4], DDL[5], Info, Trigger uses
Synonyms	Create Synonym	References, Synonym Facts, Synonyms
Synonym	Comment Synonym, Drop Synonym, Script: Create Synonym	Data, Access Rights, Columns, Constraints, DDL, Indexes, Info, Primary Key, References, Row Count, Triggers
Indexes		Index Facts, Indexes
Index	Comment Index, Drop Index	Columns, DDL
Column	Comment Column, Create Index, Data Type, Drop Column, Drop Default, Grant Column Access, Revoke Column Access, Set Default	Column, Column Privileges, Column used by, Column uses
Sequences	Create Sequence	Sequence Facts, Sequences
Sequence	Alter Sequence, Comment Sequence, Drop Sequence, Grant Usage, Revoke Usage, Script: Create Sequence	DDL, Info, Sequence used by, Sequence uses, Usage Privilege
Functions	Create Function, Create Function[3]	Function Facts, Functions
Function[3]	Export Function[4], Script: Script Function, Comment Function, Comment Function[3], Drop Function, Drop Function[3], Grant Execute, Grant Execute[3], Revoke Execute, Revoke Execute[3], Script: Test Function	Function Editor[4], DDL[5], Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
Function	Export Function[4], Script: Script Function, Comment Function, Comment Function[3], Drop Function, Drop Function[3], Grant Execute, Grant Execute[3], Revoke Execute, Revoke Execute[3], Script: Test Function	Function Editor[4], DDL[5], Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
Procedures	Create Procedure, Create Procedure[3]	Procedure Facts, Procedures
Procedure[3]	Export Procedure[4], Script: Script Procedure, Comment Procedure, Comment Procedure[3], Drop Procedure, Drop Procedure[3], Grant Execute, Grant Execute[3], Revoke Execute, Revoke Execute[3]	Procedure Editor[4], DDL[5], Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input		Parameter
Procedure	Export Procedure[4], Script: Script Procedure, Comment Procedure, Comment Procedure[3], Drop Procedure, Drop Procedure[3], Grant Execute, Grant Execute[3], Revoke Execute, Revoke Execute[3]	Procedure Editor[4], DDL[5], Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input		Parameter
Modules	Create Module	Module Facts, Modules
Module	Export Module[4], Comment Module, Drop Module	Module Editor[4], DDL[5], Info, Module routines
ModuleProcedure		DDL, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input		Parameter
ModuleFunction		DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
Types[7]		User Defined Types
DistinctTypes	Create Distinct Type	User Defined Distinct Types
DistinctType	Comment User Defined Type, Drop User Defined Type, Grant Usage, Revoke Usage	DDL, Info, Usage Privilege, User Defined Type Used By
InstanceMethods	Add Instance Method Specification	Instance Methods
InstanceMethodUndef	Create Instance Method, Drop Instance Method Specification	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
InstanceMethod	Comment Instance Method, Drop Instance Method, Grant Execute, Revoke Execute	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
StaticMethods	Add Static Method Specification	Static Methods
StaticMethodUndef	Create Static Method, Drop Static Method Specification	DDL, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
StaticMethod	Comment Static Method, Drop Static Method, Grant Execute, Revoke Execute	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
StructuredTypes	Create Structured Type	User Structured Distinct Types
StructuredType	Comment User Defined Type, Drop User Defined Type, Grant Usage, Revoke Usage	DDL, Info, Usage Privilege, User Defined Type Used By
Attributes	Add User Defined Type Attribute	User Defined Type Attributes
Attribute	Drop User Defined Type Attribute	DDL, User Defined Type Attribute
ConstructorMethods	Add Constructor Method Specification	Constructor Methods
ConstructorMethodUndef	Create Constructor Method, Drop Constructor Method Specification	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
ConstructorMethod	Comment Constructor Method, Drop Constructor Method, Grant Execute, Revoke Execute	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
InstanceMethods	Add Instance Method Specification	Instance Methods
InstanceMethodUndef	Create Instance Method, Drop Instance Method Specification	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
InstanceMethod	Comment Instance Method, Drop Instance Method, Grant Execute, Revoke Execute	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
StaticMethods	Add Static Method Specification	Static Methods
StaticMethodUndef	Create Static Method, Drop Static Method Specification	DDL, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
StaticMethod	Comment Static Method, Drop Static Method, Grant Execute, Revoke Execute	DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output		Result
Input		Parameter
Domains	Create Domain	Domain Facts, Domains
Domain	Comment Domain, Drop Domain, Grant Usage, Revoke Usage	Constraints, DDL, Domain used by, Domain uses, Info, Usage Privilege
Collations		Collation Facts, Collations
Collation		Collation used by, Collation uses, DDL, Info, Usage Privilege
Statements	Call, Delete, Insert, Select, Set, Update
Statement	Comment Statement, Drop Statement, Execute Statement, Execute Statement[3], Grant Execute, Refresh Statement, Revoke Execute
BaseTypes		Basic Data Types
BaseType		Info
Properties	Enter Program, Leave Program	Group memberships, Session Properties, System Privileges
DBA	Alter Database, Find Error Code, Set Database, Show Error Text, Update Statistics	DBA, Database Properties
Users	Create User, Create User[7]	User Facts, Users
User	Add Login Authorization[7], Alter Password, Comment User, Drop Login Authorization[7], Drop User, Grant System Privilege, Revoke System Privilege, Set Password[7], Script: Create Ident	Access rights, Column Privileges, DDL, Group memberships, Info, OS users[7], Object Privileges, Schemas, System Privileges
Programs	Create Program	Program Facts, Programs
Program	Alter Password, Comment Program, Drop Program, Enter Program, Grant Execute, Grant System Privilege, Leave Program, Revoke Execute, Revoke System Privilege, Script: Create Ident	Access rights, Column Privileges, DDL, Execute, Group memberships, Info, Object Privileges, Schemas, System Privileges
Groups	Create Group	Group Facts, Groups
Group	Comment Group, Drop Group, Grant Membership, Grant System Privilege, Revoke Membership, Revoke System Privilege, Script: Create Ident	Access rights, Column Privileges, DDL, Group memberships, Info, Members, Object Privileges, System Privileges
Databanks	Create Backup Script, Create Databank, Create Databank[3]	Databank Facts, Databanks
Databank	Add File, Add Pages[3], Comment Databank, Create Shadow, Drop Databank, Filename[3], Filename[8], Filesize[8], Goalsize[8], Grant Object Privilege, Maxsize[8], Minsize[8], Option, Option[3], Removable, Restore From File, Restore From Log, Revoke Object Privilege, Set Databank, Script: Create Databank	DDL, Databank files, Databank used by, Info, Object Privilege, Shadows
DatabankFile	Drop File, Drop Sizes, Filename, Set Sizes	DDL, Info
Shadows	Create Shadow	Shadows
Shadow	Add Pages, Drop Shadow, Filename, Set Shadow, To Master, Script: Create Shadow	DDL, Info
Subscriptions
Subscription
SqlStandards		SQL Standards
SqlStandard2003		SQL 1999 and 2003 features, SQL 1999 and 2003 languages, SQL 1999 and 2003 sizing
SqlStandard1992		SQL 1992 features, SQL 1992 sizing
[1] Only for Mimer SQL Auto [2] Only for Mimer SQL Mobile and Mimer SQL Micro [3] Mimer SQL 9.2 and earlier [4] DbVisualizer Pro [5] DbVisualizer Free [6] Not available for the "Production" permission mode [7] Mimer SQL 10.1 and later [8] Mimer SQL 10.1 and earlier