Friday, January 17, 2020

Database properties for entity shape triggers and check

Use these options to add, edit, remove, or preview the code for triggers and check clauses. The options in this category may vary depending on your specific database management system (DBMS).

When you reverse engineer a database that contains code, or when you add new code to a table in your model, the code is shown in this category and is listed under Local Code in the Code window.

Code is included in the DDL (Data Definition Language) script created when you use the Generate or Update Database Wizard.

You can execute a trigger when specific database events occur, such as when a record is inserted, updated, or deleted. For example, you can use a trigger to log audit information to a separate table, calculate derived information such as the extended cost of price times quantity, notify logged-on users of limits that have been exceeded, or call a stored procedure.

Triggers / Check clauses

Lists the code associated with the selected Entity shape.

Preview

Displays approximately four lines of code for the selected trigger or check clause.

Add

Click to open the Code Editor, in which you can write new code. You can resize the Code Editor if you want to see more of your code.

Remove

Click to delete the selected trigger or check clause.

Edit

Click to open the Code Editor and display the code for the selected trigger or check clause. You can resize the Code Editor if you want to see more of your code.

1 comment: