MySQL

Database Specific Support

The following table show the database specific support for MySQL organized per database object type.

• Object Type - show what object types are listed in the Databases tab
• Actions - show what actions are available for the object type
• Viewers - show what viewers are available for the object type

Object Type	Actions	Viewers
Databases	Create Database	Databases, Session SQL Mode1
Catalog	Export Database, Drop Database	Catalog
Tables	Create Table, Import Table Data	References, Tables
Table	Alter Table, Create Trigger, Export Table, Import Table Data, Analyze Table1, Check Table1, Checksum Table2, Create Index, Drop Table, Empty Table, Optimize Table1, Rename Table, Repair Table1, Script: Script Table	Navigator3, References, Data, Columns, DDL, Grants, Indexes, Info, Native DDL, Primary Key, Row Count, Row Id, Triggers4
Columns		Columns
Column		Column
Indexes		Indexes
Index	Drop Index	Index
Triggers4		Triggers
Trigger	Export Trigger, Drop Trigger	Trigger Editor, Info
Views4		Views
View	Export View, Drop View, Rename View, Script: Script View	Data, Columns, DDL4, Grants, Info, Row Count
Columns		Columns
Column		Column
Procedures4	Create Procedure	Stored Procedures
Procedure	Export Procedure, Drop Procedure, Script: Script Procedure	Procedure Editor, Info
Functions4	Create Function	User Functions
Function	Export Function, Drop Function, Script: Script Function	Function Editor, Info
Triggers4		Triggers
Trigger	Export Trigger, Drop Trigger	Trigger Editor, Info
Events5	Create Event, Start/Stop Event Scheduler	Events
Event	Alter Event, Drop Event, Enable/Disable Event, Rename Event	Info
DBA		DBA
Users	Create User	Users
Login	Drop User	Privileges, Show Grants
Privileges1		Server Privileges
Processes		Processes
Process	Kill Session	Process
Status		Charset1, Colllation1, Slave Hosts1, Slave Status1, Status, Variables
TableEngines1		Table Engines
TableEngine		Mutex, Status
Warnings4		Errors, Warnings
1) Version 4.1 and later 2) Version 4.2 and later 3) DbVisualizer Pro 4) Version 5.0 and later 5) Version 5.2 and later