The Database Objects form describes views, stored procedures, triggers, and functions. First, Last, and Instead Of triggers can be defined in Database Objects records.

Top Panel

Name (Required)

The Name field stores the name of the database object.

Description

The Description field stores the description of the database object. If the database object is automatically generated, this is included in the description.

DB (Required)

The Database field holds the name of the SQL Server database that houses the database object.

Type (Required)

The type of database object. Available options are:

• View: A virtual table, often used to filter data or to join data from multiple tables.
• Stored Procedure: A group of Transact-SQL statements combined into one execution plan. Can be used to return data and to implement business logic.
• Trigger: Stored procedure designed to execute automatically whenever an Update, Insert, or Delete command is run against the specified table or view. Used to enforce integrity logic or business rules.
• Function: User defined Transact-SQL functions take zero or more input parameters and return a single value.

Grant SQL Tab

The Grant SQL tab stores the portion of the SQL statement that identifies who has permissions to use the database object.

Required DB Objects Tab

Aptify provides the ability to pack or unpack certain entities and their related database objects. When an entity is unpacked, all information tied to the entity also be unpacked and configured on the destination server. If items are left unlinked to a given entity or database object, they can not be packed and may be missing on the destination server.

It is critical that all required database objects be linked via the Required DB Objects section. This enables them to be correctly packed and unpacked when appropriate.

SQL Tab

This section provides the ability to create the SQL statement for the database object, and is made of three components: Recompile button, Format button, and a multi-line text box.

The multi-line text box is the tool provided to encapsulate the body of the stored procedure, view, or trigger. Once the SQL text has been entered, the Format button alters the look of the text, changing the color of reserved words and characters. If you paste unformatted text from another source into the record, you can click the Format button to update the formatting. The Recompile button allows the SQL text to be recompiled after modifications have been applied.