Other database objects

 

Note: this page is outdated. Please visit Other database objects in MariaDB projects

 

Specific database objects

Diagrams can also contain graphical representatives of various database objects. The following objects can be added to MySQL diagrams:

• Views
• Stored procedures
• Functions
• Triggers
• Other objects (Events, Table check constraints, User/Role definitions)

Each object has its default color that can be changed. Objects can be repositioned, aligned, enlarged, etc.

Usage:

To add a new object, click Other on the toolbar or right-click the diagram area and choose the desired object type, for example, Function.

In object properties, specify colors and Code. The code will be saved together with SQL statements for other objects like tables and relations.

Other objects are displayed in lists in the left-side panel.

 

#