Mimer SQL - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.5
October 2008 		http://www.dbvis.com
support@dbvis.com

[ Master documentation index ]

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the Mimer SQL RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a Mimer database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.  

Object Type Actions Viewers
Statements1
Script: Call, Script: Delete, Script: Insert, Script: Select, Script: Set, Script: Update
Statement
Comment Statement, Drop Statement, Execute Statement, Grant Execute, Refresh Statement, Revoke Execute
Schemas
Create Schema Schemas
Schema
Export Schema, Drop Schema Info
Tables
Create Table3, Update Statistics References, Table Facts, Tables
Table
Import Table Data, Create Trigger, Alter Table, Create Index, Add Check, Add Column, Add Foreign Key, Add Primary/Unique Key, Comment Table, Drop Column, Drop Constraint, Drop Table, Empty Table4, Grant Access, Revoke Access, Update Statistics, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator, Access Rights, Columns, Comments, Constraints, DDL, Data, Indexes, Info, Mimer DDL3, Primary Key, Row Count, Subscriptions, Table used by, Table uses, Triggers
Columns

Columns
Column
Comment Column, Data Type, Drop Column, Drop Default, Grant Column Access, Revoke Column Access, Set Default Column, Column Privileges, Column used by
Triggers
Create Table Trigger, Create View Trigger Trigger Facts, Triggers
Trigger
Comment Trigger, Drop Trigger Trigger Editor, DDL3, Info, Trigger uses
Views
Script: Create View View Facts, Views
View
Comment View, Create Trigger, Drop View, Grant Access, Revoke Access, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Access Rights, Columns, Comments, DDL, Data, Info, References, Row Count, Triggers, View used by, View uses
Columns

Columns
ViewColumn
Comment Column, Grant Column Access, Revoke Column Access Column, Column Privileges, Column used by
Triggers
Create Table Trigger, Create View Trigger Trigger Facts, Triggers
Trigger
Comment Trigger, Drop Trigger Trigger Editor, DDL3, Info, Trigger uses
Triggers
Create Table Trigger, Create View Trigger Trigger Facts, Triggers
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, Index, Info
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 Function Facts, Functions
Function2
Comment Function, Comment Function2, Drop Function, Drop Function2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2, Script: Test Function Function Editor, DDL3, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output

Result
Input

Parameter
Function
Comment Function, Comment Function2, Drop Function, Drop Function2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2, Script: Test Function Function Editor, DDL3, Execute Privilege, Function used by, Function uses, Info, Parameters, Result
Output

Result
Input

Parameter
Procedures
Create Procedure Procedure Facts, Procedures
Procedure2
Comment Procedure, Comment Procedure2, Drop Procedure, Drop Procedure2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2 Procedure Editor, DDL3, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input

Parameter
Procedure
Comment Procedure, Comment Procedure2, Drop Procedure, Drop Procedure2, Grant Execute, Grant Execute2, Revoke Execute, Revoke Execute2 Procedure Editor, DDL3, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses
Input

Parameter
Modules
Create Module Module Facts, Modules
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
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, Grant Execute, Refresh Statement, Revoke Execute
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 User Facts, Users
User
Alter Password, Comment User, Drop User, Grant System Privilege, Revoke System Privilege, Script: Create Ident Access rights, Column Privileges, DDL, Group memberships, Info, 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, 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)Only in DbVisualizer Personal
4)Not available for the "Production" connection mode




Copyright © 2008 Onseven Software AB. All rights reserved.