Image
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
Image Image Mimer SQL Auto[1]
   Mimer SQL Auto
Image Image Statements[2]
 Call, Delete, Insert, Select, Set, Update  
Image Image Statement
 Comment Statement, Drop Statement, Execute Statement, Execute Statement[3], Grant Execute, Refresh Statement, Revoke Execute  
Image Image Schemas
 Create Schema Schema Facts, Schemas
Image Image Schema
 Export Schema[4], Comment Schema, Drop Schema Comments, Info
Image Image Tables
 Create Table[4], Import Table Data[4], Create Table[5], Update Statistics References, Table Facts, Tables
Image Image 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]
Image Image Columns
   Columns
Image Image 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
Image Image Constraints
 Add Check, Add Foreign Key, Add Primary/Unique Key Constraints
Image Image Constraint
 Drop Constraint Constraint, DDL
Image Image 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
Image Image Indexes
   Index Facts, Indexes
Image Image Index
 Comment Index, Drop Index Columns, DDL
Image Image 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
Image Image Triggers
 Create Table Trigger, Create View Trigger Trigger Facts, Triggers
Image Image Trigger
 Export Trigger[4], Comment Trigger, Drop Trigger Trigger Editor[4], DDL[5], Info, Trigger uses
Image Image Access Paths[7]
   Access Paths
Image Image Access Path
 Drop Access Path Access Path, Columns
Image Image Access Path Column
   Column
Image Image Views
 Script: Create View View Facts, Views
Image Image 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
Image Image Columns
   Columns
Image Image View Column
 Comment Column, Grant Column Access, Revoke Column Access Column, Column Privileges, Column used by, Column uses
Image Image Triggers
 Create Table Trigger, Create View Trigger Trigger Facts, Triggers
Image Image Trigger
 Export Trigger[4], Comment Trigger, Drop Trigger Trigger Editor[4], DDL[5], Info, Trigger uses
Image Image Triggers
 Create Table Trigger, Create View Trigger Trigger Facts, Triggers
Image Image Trigger
 Export Trigger[4], Comment Trigger, Drop Trigger Trigger Editor[4], DDL[5], Info, Trigger uses
Image Image Synonyms
 Create Synonym References, Synonym Facts, Synonyms
Image Image Synonym
 Comment Synonym, Drop Synonym, Script: Create Synonym Data, Access Rights, Columns, Constraints, DDL, Indexes, Info, Primary Key, References, Row Count, Triggers
Image Image Indexes
   Index Facts, Indexes
Image Image Index
 Comment Index, Drop Index Columns, DDL
Image Image 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
Image Image Sequences
 Create Sequence Sequence Facts, Sequences
Image Image Sequence
 Alter Sequence, Comment Sequence, Drop Sequence, Grant Usage, Revoke Usage, Script: Create Sequence DDL, Info, Sequence used by, Sequence uses, Usage Privilege
Image Image Functions
 Create Function, Create Function[3] Function Facts, Functions
Image Image 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
Image Image Output
   Result
Image Image Input
   Parameter
Image Image 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
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Procedures
 Create Procedure, Create Procedure[3] Procedure Facts, Procedures
Image Image 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
Image Image Input
   Parameter
Image Image 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
Image Image Input
   Parameter
Image Image Modules
 Create Module Module Facts, Modules
Image Image Module
 Export Module[4], Comment Module, Drop Module Module Editor[4], DDL[5], Info, Module routines
Image Image Module Procedure
   DDL, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Image Image Input
   Parameter
Image Image Module Function
   DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image User defined types[7]
   User Defined Types
Image Image Distinct Types
 Create Distinct Type User Defined Distinct Types
Image Image Distinct Type
 Comment User Defined Type, Drop User Defined Type, Grant Usage, Revoke Usage DDL, Info, Usage Privilege, User Defined Type Used By
Image Image Instance Methods
 Add Instance Method Specification Instance Methods
Image Image Instance Method Undef
 Create Instance Method, Drop Instance Method Specification DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Instance Method
 Comment Instance Method, Drop Instance Method, Grant Execute, Revoke Execute DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Static Methods
 Add Static Method Specification Static Methods
Image Image Static Method Undef
 Create Static Method, Drop Static Method Specification DDL, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Static Method
 Comment Static Method, Drop Static Method, Grant Execute, Revoke Execute DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Structured Types
 Create Structured Type User Structured Distinct Types
Image Image Structured Type
 Comment User Defined Type, Drop User Defined Type, Grant Usage, Revoke Usage DDL, Info, Usage Privilege, User Defined Type Used By
Image Image Attributes
 Add User Defined Type Attribute User Defined Type Attributes
Image Image Attribute
 Drop User Defined Type Attribute DDL, User Defined Type Attribute
Image Image Constructor Methods
 Add Constructor Method Specification Constructor Methods
Image Image Constructor Method Undef
 Create Constructor Method, Drop Constructor Method Specification DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Constructor Method
 Comment Constructor Method, Drop Constructor Method, Grant Execute, Revoke Execute DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Instance Methods
 Add Instance Method Specification Instance Methods
Image Image Instance Method Undef
 Create Instance Method, Drop Instance Method Specification DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Instance Method
 Comment Instance Method, Drop Instance Method, Grant Execute, Revoke Execute DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Static Methods
 Add Static Method Specification Static Methods
Image Image Static Method Undef
 Create Static Method, Drop Static Method Specification DDL, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Static Method
 Comment Static Method, Drop Static Method, Grant Execute, Revoke Execute DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Image Image Output
   Result
Image Image Input
   Parameter
Image Image Domains
 Create Domain Domain Facts, Domains
Image Image Domain
 Comment Domain, Drop Domain, Grant Usage, Revoke Usage Constraints, DDL, Domain used by, Domain uses, Info, Usage Privilege
Image Image Collations
   Collation Facts, Collations
Image Image Collation
   Collation used by, Collation uses, DDL, Info, Usage Privilege
Image Image Statements
 Call, Delete, Insert, Select, Set, Update  
Image Image Statement
 Comment Statement, Drop Statement, Execute Statement, Execute Statement[3], Grant Execute, Refresh Statement, Revoke Execute  
Image Image Data types
   Basic Data Types
Image Image Base Type
   Info
Image Image Session Properties
 Enter Program, Leave Program Group memberships, Session Properties, System Privileges
Image Image DBA Views
 Alter Database, Find Error Code, Set Database, Show Error Text, Update Statistics DBA, Database Properties
Image Image Users
 Create User, Create User[7] User Facts, Users
Image Image 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
Image Image Programs
 Create Program Program Facts, Programs
Image Image 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
Image Image Groups
 Create Group Group Facts, Groups
Image Image 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
Image Image Databanks
 Create Backup Script, Create Databank, Create Databank[3] Databank Facts, Databanks
Image Image 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
Image Image Databank File
 Drop File, Drop Sizes, Filename, Set Sizes DDL, Info
Image Image Shadows
 Create Shadow Shadows
Image Image Shadow
 Add Pages, Drop Shadow, Filename, Set Shadow, To Master, Script: Create Shadow DDL, Info
Image Image Subscriptions
    
Image Image Subscription
    
Image Image SQL Standards
   SQL Standards
Image Image SQL 1999 and 2003
   SQL 1999 and 2003 features, SQL 1999 and 2003 languages, SQL 1999 and 2003 sizing
Image Image SQL 1992
   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