MySQL

MySQL object type support.

The following table shows the database specific support in DbVisualizer 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
Catalog
Export Database[1], Drop Database Database
Tables
Create Table[1], Import Table Data[1] References, Tables
Table
Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Analyze Table[2], Check Table[2], Checksum Table[3], Create Index, Drop Table, Empty Table, Optimize Table[2], Rename Table, Repair Table[2] Navigator[1], References, Data, Columns, DDL[1], Grants, Indexes, Info, Native DDL, Primary Key, Row Count, Row Id, Triggers[4]
Columns
  Columns
Column
  Column
Indexes
  Indexes
Index
Drop Index Index
Triggers[4]
  Triggers
Trigger
Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Views[4]
  Views
View
Export View[1], Script: Script View, Drop View, Rename View Data, Columns, DDL[4][1], Grants, Info, Row Count
Columns
  Columns
Column
  Column
Procedures[4]
Create Procedure Stored Procedures
Procedure
Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1], Info
Functions[4]
Create Function User Functions
Function
Export Function[1], Script: Script Function, Drop Function Function Editor[1], Info
Triggers[4]
  Triggers
Trigger
Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Events[5]
Create Event, Start/Stop Event Scheduler Events
Event
Alter Event, Drop Event, Enable/Disable Event, Rename Event Info
DBA
  DBA
Users
Create User Users
User
Drop User Privileges, Show Grants
Privileges[2]
  Server Privileges
Processes
  Processes
Process
Kill Session Process
Status
  Charset[2], Collation[2], Session SQL Mode[2], Slave Hosts[2], Slave Status[2], Status, Variables
TableEngines[2]
  Table Engines
TableEngine
  Mutex, Status
Warnings[4]
  Errors, Warnings
[1] DbVisualizer Pro
[2] Version 4.1 and later
[3] Version 4.2 and later
[4] Version 5.0 and later
[5] Version 5.2 and later
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗