MySQL
The following table shows the database specific support in DbVisualizer for MySQL organized per database 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, Load Table Data, 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 | |
Stored Procedures[4] | Create Procedure | Stored Procedures |
Procedure | Export Procedure[1], Script: Script Procedure, Drop Procedure | Procedure Editor[1], Info |
User 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 Views | 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], Replica Status[7], Replicas[7], Session SQL Mode[2], Slave Hosts[6], Slave Status[6], Status, Variables | |
Storage Engines[2] | Table Engines | |
Table Engine | Mutex, Status | |
Errors and 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 [6] Version 4.1 to 8.4.9 [7] Version 9.0 and later | ||