Step 4: Manage Data

On the Objects tab page, choose Tables. Click Create Table and specify information such as the table name and storage engine.
Ensure the settings are correct and click Next. Then add table columns.
Click Next and add virtual columns, indexes, and foreign keys.
Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the table if everything is correct.

On the Objects tab page, choose Views. Click Create View and specify information such as the view name, algorithm, security, and view definition statement.
Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the view if everything is correct.

On the Objects tab page, choose Stored Procedures. Click Create Stored Procedure and specify the name and description.
Ensure the settings are correct and click OK. The SQL preview page is displayed.
Click Option and configure information such as SQL security and data access.
Ensure the settings are correct, and click OK and then Save. If you want to modify the SQL statement, click Cancel to go back to the SQL preview window.
Click Execute to create a stored procedure.

On the Objects tab page, choose Events. Click Create Event and specify information such as the event name, status, remarks, and event definition statements.
Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the event if everything is correct.

On the Objects tab page, choose Triggers. Click Create Trigger and specify information such as the trigger name, trigger table, trigger condition, trigger event, and trigger definition statement.
Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the trigger if everything is correct.

On the Objects tab page, choose Functions. Click Create Function and specify information such as the function name and description.
Ensure the settings are correct and click OK. The SQL preview page is displayed.
Click Option and configure information such as SQL security and data access.
Ensure the settings are correct, and click OK and then Save. If you want to modify the SQL statements, click Cancel to go back to the SQL preview window. Then click Execute to create the function.

Была ли эта статья полезна?