DbVisualizer - Mimer SQL - Database Specific Support

Mimer SQL - Database Specific Support
DbVisualizer 5.1 October 2006	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

Schemas

Create Schema

Schemas

Schema

Drop Schema

Info

Tables

Create Table, Update Statistics

References, Table Facts, Tables

Table

Add Check, Add Column, Add Foreign Key, Add Primary/Unique Key, Comment Table, Create Index, Create Trigger, Drop Column, Drop Constraint, Drop Table, Empty Table³, Grant Access, Import Table Data, Revoke Access, Update Statistics, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE

Access Rights, Columns, Comments, Constraints, DDL, Data, Indexes, Info, Primary Key, References, Row Count, Table used by, Table uses, Triggers

Column

Comment Column, Data Type, Drop Column, Drop Default, Grant Column Access, Revoke Column Access, Set Default

Column, Column Privileges, Column used by

Views

Script: Create View

References, 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

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

DDL, 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, 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, Usage Privilege

Functions

Create Function

Function Facts, Functions

Function

Comment Function, Drop Function, Grant Execute, Revoke Execute, Script: Test Function

DDL, Execute Privilege, Function used by, Function uses, Info, Parameters, Result

Output

Result

Input

Parameter

Procedures

Create Procedure

Procedure Facts, Procedures

Procedure

Comment Procedure, Drop Procedure, Grant Execute, Revoke Execute

DDL, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses

Input

Parameter

Modules

Create Module

Module Facts, Modules

Module

Comment Module, Drop Module

DDL, Info, Module routines

Procedure

Comment Procedure, Drop Procedure, Grant Execute, Revoke Execute

DDL, Execute Privilege, Info, Parameters, Procedure used by, Procedure uses

Input

Parameter

Function

Comment Function, Drop Function, Grant Execute, Revoke Execute, Script: Test Function

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 Statement², Grant Execute, Refresh Statement, Revoke Execute

Properties

Enter Program, Leave Program

Group memberships, Session Properties, System Privileges

DBA

Find Error text, Set Database, Show Error Text, Update Statistics

DBA

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, Execute Privileges, Group memberships, Info, Schemas, System Privileges, Table Privileges, Usage 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, Execute Privileges, Group memberships, Info, Schemas, System Privileges, Table Privileges, Usage 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, Execute Privileges, Group memberships, Info, Members, System Privileges, Table Privileges, Usage Privileges

Databanks

Create Databank, Create Databank², Script: Create Backup Script

Databank Facts, Databanks

Databank

Add Pages², Comment Databank, Create Shadow, Drop Databank, Drop Filesize, Drop Goalsize, Drop Maxsize, Drop Minsize, Filename², Grant Table Privilege, Option², Restore From File, Restore From Log, Revoke Table Privilege, Set Databank, Set Filename⁴, Set Filesize⁴, Set Goalsize⁴, Set Maxsize⁴, Set Minsize⁴, Set Option⁴, Script: Create Databank

DDL, Databank used by, Info, Shadows, Table Privilege