Item Properties/Editor

This window is displayed when the Properties is selected from the Project Definition right-click menu after selecting an item. It consists of three tabs, two of them are always visible, one is visible only for specific types of items such as Custom Action and SQL script. See Supported Items.

For Item Dependencies, see Project Properties Item Dependencies Tab.

General Properties tab displays basic properties of the item:

• Name – name of the item.
• Type – type of the item. In case of Database Object items, the item type is displayed together with its database type (e.g., Database Stored Procedure (MS SQL)).
• Attached to Project – defines a way in which an item was added to a Project.
• Explicitly – the item was added manually using Add Item Wizard.
• Implicitly – the item was added automatically because it was needed by another item added manually.
• Comment – optional comment to the item.

Editor tab's visibility depends on type of the item. For example for Custom Action and SQL Editor items, this tab is visible.

SQL Script Editor enables editing/viewing the script. An empty SQL Script Editor is displayed when building a personal SQL script within the Add activity in the Add Item Wizard (for SQL script). The script is included in the future Package and executed on the Destination database after deployment. The Editor helps you build a script by color coding the script elements while validating them. Loading a predefined script (or script fragment) from an external file is possible (in Editor mode) during editing through use of the Load from File... button (the contents of the Editor will be replaced in this case).

To learn more about different types of items, see Supported Items.

History tab displays list of revisions of the item with comments from the SubVersion Repository. It is visible only if a SubVersion Repository was defined for the Project (see Source Repositories)