Use the UDP tab in a SQL Server physical property editor to add a user-defined property for an object in a SQL Server 2000, 2005, or 2008 physical model.
To add a UDP in a SQL Server physical property editor
The User Defined Properties : Physical dialog opens.
Lets you specify the name of the UDP.
Lets you specify the UDP data type. Click the cell and select one of the following data types from the drop-down list:
Command
Creates a UDP that launches a file or application.
Date
Creates a UDP to allow dates in MM/DD/YYYY format.
Int
Creates a UDP so you can enter an integer (whole number).
Real
Creates a UDP so you can enter a real number (with decimal).
Text
Creates a UDP so you can enter ASCII text.
List
Creates a UDP so you can create a list box with user-defined choices.
Lets you specify a UDP default value when applicable.
Lets you enter a description for the UDP.
Lets you specify whether to allow forward engineering of the UDP to the database as an extended property. Select True from the drop-down to include the UDP in forward engineering, or False to not include it. The default setting is False.
Note: To ensure the UDP is included in the forward engineering action, you must also select the User Defined Properties option in the Other Options section of the Forward Engineer Schema Generation dialog.
The UDP is added, the User Defined Properties : Physical dialog closes, and you are returned to the UDP tab in the property editor.
The property editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|