MySQL - Database Specific Support

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 Import Table Data, Create Table References, Tables Table Export 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, Navigator1, Columns, DDL, Data, Grants, Indexes, Info, Native DDL, Primary Key, Row Count, Row Id, Triggers2 Columns   Columns Column   Column Indexes   Indexes Index Drop Index Index Triggers   Triggers Trigger Drop Trigger Trigger Editor, Info Views2   Views View Drop View, Rename View, Script: CREATE VIEW2, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL2, Data, Grants, Info, Row Count Procedures2 Create Procedure Stored Procedures Procedure Drop Procedure, Script: CALL Procedure Editor, Info Functions2 Create Function User Functions Function Drop Function, Script: CALL Function Editor, Info Triggers2   Triggers Trigger Drop Trigger Trigger Editor, Info DBA   DBA Users   Users Login   Grants Roles3   Server Roles Processes   Processes Process Kill Session Process Status   Status, Variables TableEngines3   Table Engines Errors2   Errors 1) DbVisualizer Personal 2) Version 5.0 and later 3) Version 4.1 and later

---