You can modify an object's properties from its property sheet. To open a procedure property sheet, double-click its diagram symbol or its Browser entry in the Procedures folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for procedures.
Property |
Description |
---|---|
Name |
Specifies the name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
Code |
Specifies the technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
Comment |
Specifies a descriptive label for the procedure. |
Stereotype |
Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined. |
Owner |
Specifies the name of the procedure owner. |
Table |
Specifies the table to which the procedure is attached. You can use the tools to the right of the list to create an object, browse the complete tree of available objects or view the properties of the currently selected object. |
The following tabs are also available:
Definition - allows you to enter the SQL code for the procedure. For information about the tools available, see SQL Code Definition Toolbars.