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