Database Management

After opening the link, you can see the database management interface, and you can add, delete, modify, and query the database.

Switch link

Click the Switch Link button in the upper right corner to switch links.

View management database

• After selecting the link, you can see the database list. Click on the database name to view the database details.
• Click the "+" in the upper left corner to create a new database, and click the "Refresh" button in the upper left corner to refresh the database list.
• Right-click on databse to refresh, copy and other operations.

View management table

The tables interface can view the tables in the database. You can create, refresh, view all tables, and refresh all tables.

Create a new edit table

Create a new form and fill in basic information

• Table Name: table name
• Comment: table comment
• Character set: character set
• Engine: storage engine
• Increment value: self-increment start value

Fill in column information

• Column Name: column name
• Type: type
• Size: length
• Nullable: whether it is empty
• Key: primary key
• Comment: comment

• Index Name: index name
• Column: column name
• Type: index type
• Comment: comment

View management view

Click view on the left menu to view the views in the database. You can create, refresh, view all views, or refresh all views. Double-click to view view details.

View management index

Click on the left menu indexes to view the indexes in the database. You can create, refresh, view all indexes, or refresh all indexes.

View management trigger

Click on the left menu triggers to view the triggers in the database. You can create new triggers, refresh them, view all triggers, or refresh all triggers.

View management function

Click on the left menu functions to view the functions in the database. You can create, refresh, view all functions, and refresh all functions.