Mimer SQL
The following table shows the database specific support in DbVisualizer for Mimer SQL organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
Mimer SQL Auto[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, Update Statistics | References, Table Facts, Tables |
Table | Create Trigger, Export Table[4], Import Table Data[4], Script: Script Table, Add Check, Add Column, Add Foreign Key, Add Primary Key, Add Unique Key, Comment Table, Create Index, Drop Column, Drop Constraint, Drop Index, Drop Table, Empty Table[5], Grant Access, Revoke Access, Update Statistics | Navigator[4], References, Data, Access Rights, Comments, DDL, Info, 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 Key, Add Unique Key | Constraints |
Constraint | Drop Constraint | Columns, DDL, Info |
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, info |
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[6], Info, Trigger uses |
Access Paths[7] | Access Paths | |
Access Path | Drop Access Path | Access Path, Columns |
Access Path Column | 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 | |
View Column | 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[6], 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[6], 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, info |
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[6], 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[6], 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[6], 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[6], 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[6], Info, Module routines |
Module Procedure | DDL, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses | |
Input | Parameter | |
Module Function | DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result | |
Output | Result | |
Input | Parameter | |
User defined types[7] | User Defined Types | |
Distinct Types | Create Distinct Type | User Defined Distinct Facts, User Defined Distinct Types |
Distinct Type | Comment User Defined Type, Drop User Defined Type, Grant Usage, Revoke Usage | DDL, Info, Usage Privilege, User Defined Type Used By |
Instance Methods | Add Instance Method Specification | Instance Methods |
Instance Method Undef | Create Instance Method, Drop Instance Method Specification | DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result |
Output | Result | |
Input | Parameter | |
Instance Method | 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 | |
Static Methods | Add Static Method Specification | Static Methods |
Static Method Undef | Create Static Method, Drop Static Method Specification | DDL, Function uses, Info, Parameters, Result |
Output | Result | |
Input | Parameter | |
Static Method | 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 | |
Structured Types | Create Structured Type | User Structured Distinct Types |
Structured Type | 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 |
Constructor Methods | Add Constructor Method Specification | Constructor Methods |
Constructor Method Undef | Create Constructor Method, Drop Constructor Method Specification | DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result |
Output | Result | |
Input | Parameter | |
Constructor Method | 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 | |
Instance Methods | Add Instance Method Specification | Instance Methods |
Instance Method Undef | Create Instance Method, Drop Instance Method Specification | DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result |
Output | Result | |
Input | Parameter | |
Instance Method | 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 | |
Static Methods | Add Static Method Specification | Static Methods |
Static Method Undef | Create Static Method, Drop Static Method Specification | DDL, Function uses, Info, Parameters, Result |
Output | Result | |
Input | Parameter | |
Static Method | 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 | |
Data types | Basic Data Types | |
Base Type | Info | |
Session Properties | Enter Program, Leave Program | Group memberships, Session Properties, System Privileges |
DBA Views | 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 |
Databank File | 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 | ||
SQL Standards | SQL Standards | |
SQL 1999 and 2003 | SQL 1999 and 2003 features, SQL 1999 and 2003 languages, SQL 1999 and 2003 sizing | |
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] Not available for the "Production" permission mode [6] DbVisualizer Free [7] Mimer SQL 10.1 and later [8] Mimer SQL 10.1 and earlier | ||