Mimer SQL Tested for version 9.1 - 11
Overview JDBC Drivers Features Supported Objects Download

Mimer SQL

Mimer SQL object type support.

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