Database specific support for Mimer SQLDatabase specific support for Mimer SQL

The following table show the database specific support for Database specific support 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 Type Actions Viewers
Statements1
Script: Call, Script: Delete, Script: Insert, Script: Select, Script: Set, Script: Update  
Statement
Comment Statement, Drop Statement, Execute Statement, Execute Statement2, Grant Execute, Refresh Statement, Revoke Execute  
Schemas
Create Schema Schema Facts, Schemas
Schema
Export Schema, Comment Schema, Drop Schema Comments, Info
Tables
Create Table, Import Table Data, Create Table3, Update Statistics References, Table Facts, Tables
Table
Alter Table, Create Trigger, Import Table Data, Add Check, Add Column, Add Foreign Key, Add Primary/Unique Key, Comment Table, Create Index, Drop Column, Drop Constraint, Drop Index, Drop Table, Empty Table4, Export Table, Grant Access, Revoke Access, Update Statistics, Script: Script Table Navigator5, References, Access Rights, Comments, DDL, DDL3, Data, Indexes, Info, Primary Key, Row Count, Subscriptions, Table used by, Table uses
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, Comment Trigger, Drop Trigger Trigger Editor, DDL3, Info, Trigger uses
AccessPaths6
  Access Paths
AccessPath
Drop Access Path Access Path, Columns
AccessPathColumn
  Column
Views
Script: Create View View Facts, Views
View
Export View, Comment View, Create Trigger, Drop View, Grant Access, Revoke Access, Script: Script View Access Rights, Comments, DDL, Data, 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, Comment Trigger, Drop Trigger Trigger Editor, DDL3, Info, Trigger uses
Triggers
Create Table Trigger, Create View Trigger Trigger Facts, Triggers
Trigger
Export Trigger, Comment Trigger, Drop Trigger Trigger Editor, DDL3, Info, Trigger uses
Synonyms
Create Synonym References, Synonym Facts, Synonyms
Synonym
Comment Synonym, Drop Synonym, Script: Create Synonym Access Rights, Columns, Constraints, DDL, Data, 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 Function2 Function Facts, Functions
Function2
Export Function, Comment Function, Comment Function2, Drop Function, Drop Function2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2, Script: Script Function, Script: Test Function Function Editor, DDL3, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output
  Result
Input
  Parameter
Function
Export Function, Comment Function, Comment Function2, Drop Function, Drop Function2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2, Script: Script Function, Script: Test Function Function Editor, DDL3, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output
  Result
Input
  Parameter
Procedures
Create Procedure, Create Procedure2 Procedure Facts, Procedures
Procedure2
Export Procedure, Comment Procedure, Comment Procedure2, Drop Procedure, Drop Procedure2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2, Script: Script Procedure Procedure Editor, DDL3, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input
  Parameter
Procedure
Export Procedure, Comment Procedure, Comment Procedure2, Drop Procedure, Drop Procedure2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2, Script: Script Procedure Procedure Editor, DDL3, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input
  Parameter
Modules
Create Module Module Facts, Modules
Module
Export Module, Comment Module, Drop Module Module Editor, DDL3, 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
Types6
  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
Script: Call, Script: Delete, Script: Insert, Script: Select, Script: Set, Script: Update  
Statement
Comment Statement, Drop Statement, Execute Statement, Execute Statement2, 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 text, Set Database, Show Error Text, Update Statistics DBA, Database Properties
Users
Create User, Create User6 User Facts, Users
User
Add Login Authorization6, Alter Password, Comment User, Drop Login Authorization6, Drop User, Grant System Privilege, Revoke System Privilege, Set Password6, Script: Create Ident Access rights, Column Privileges, DDL, Group memberships, Info, OS users7, 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 Databank, Create Databank2, Script: Create Backup Script Databank Facts, Databanks
Databank
Add Pages2, Comment Databank, Create Shadow, Drop Databank, Filename, Filename2, Filesize, Goalsize, Grant Object Privilege, Maxsize, Minsize, Option, Option2, Removable, Restore From File, Restore From Log, Revoke Object Privilege, Set Databank, Script: Create Databank DDL, Databank used by, Info, Object Privilege, Shadows
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 Mobile and Mimer SQL Micro
2) Mimer SQL 9.2 and earlier
3) DbVisualizer Free
4) Not available for the "Production" permission mode
5) DbVisualizer Pro
6) Mimer SQL 10.1 and later
7) (#dm.getDatabaseMajorVersion()gt10or(#dm.getDatabaseMajorVersion()eq10and#dm.getDatabaseMinorVersion()gt0))