MariaDB
MariaDB Tested for version 10.4+
Overview JDBC Drivers Features Supported Objects Download

MariaDB

MariaDB object type support.

The following table shows the database specific support in DbVisualizer for MariaDB 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 TypeActionsViewers
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[5], Create Procedure[6] Stored Procedures
Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1], Info
User Functions[4]
 Create Function[5], Create Function[6] 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[7]
 Create Event, Start/Stop Event Scheduler Events
Event
 Alter Event, Drop Event, Enable/Disable Event, Rename Event Info
Sequences[8]
 Create Sequence Sequences
Sequence
 Script: Script Sequence, Drop Sequence, Rename Sequence DDL[1], Info
Packages
 Create Package Packages
Package
 Create Package Body, Export Package[1], Drop Package and Package Body Package Specification Editor[1]
Package Body
 Export Package Body[1], Drop Package Body Package Body Editor[1]
Package Bodies
 Create Package Body Package Bodies
Package Body
 Export Package Body[1], Drop Package Body Package Body Editor[1]
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[10], Replicas[10], Session SQL Mode[2], Slave Hosts[9], Slave Status[9], 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] Using ORACLE_SQLMODE
[6] Using ORACLE_SQLMODE
[7] Version 10.4 and later
[8] Version 10.3 and later
[9] Version 4.1 and lateror#util.isDatabaseVersionGTE(10,6)
[10] drop-on-condition:#util.isDatabaseVersionLT(10,6)