MySQL - Database Specific Support

 DbVisualizer Logo
DbVisualizer 5.1
October 2006 		http://www.dbvis.com
[email protected]

[ 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
Drop Database
Tables
Create Table References, Tables
Table
Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Grants, Indexes, Info, Primary Key, References, Row Count, Row Id
Views1
References, 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 DDL, Info
Functions1
Create Function User Functions
Function
Drop Function DDL, Info
Triggers1
Triggers
Trigger
DDL, 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 version 5 or later
2) MySQL version 4.1 or later



Copyright © 2006 Onseven Software AB. All rights reserved.