MySQL - 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 MySQL RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a MySQL 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
Databases
Create Database Databases
Catalog
Export Database, Drop Database
Tables
Create Table References, Tables
Table
Import Table Data, Create Trigger, Alter Table, Create Index, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator, Columns, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers1
Columns

Columns
Column

Column
Indexes

Indexes
Index
Drop Index Index
Triggers

Triggers
Trigger
Drop Trigger Trigger Editor, Info
Views1

Views
View
Drop View, Rename View, Script: CREATE VIEW1, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL1, Data, Grants, Info, Row Count
Procedures1
Create Procedure Stored Procedures
Procedure
Drop Procedure Procedure Editor, Info
Functions1
Create Function User Functions
Function
Drop Function Function Editor, Info
Triggers1

Triggers
Trigger
Drop Trigger Trigger Editor, Info
DBA

DBA
Users

Users
Login

Grants
Roles2

Server Roles
Processes

Processes
Process
Kill Session Process
Status

Status, Variables
TableEngines2

Table Engines
Errors1

Errors
1)MySQL 5 or later
2)MySQL 4.1 or later




Copyright © 2008 Onseven Software AB. All rights reserved.