Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create or alter a default
Select the Default node under the Programmability node in the Object Explorer.
To bind a default to a column
Select the Default node under the Programmability node in the Object Explorer.
Complete the fields as necessary. Review the following for additional information:
Table |
Select the table on which you want to bind defaults. |
Unbound columns |
Select one or more columns and click > to bind them to the table. |
To bind a default to user-defined data type
Select the Default node under the Programmability node in the Object Explorer.
Complete the fields as necessary. Review the following for additional information:
Bind |
Select the checkbox beside each user-defined data type you want to bind to this default. |
Future Only |
Select the checkbox beside a bound data type if you want to check existing values in the column against the default value. If this checkbox is cleared, existing values are not checked. |
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create or alter a synonym
Complete the fields as necessary. Review the following for additional information:
Server |
Description |
Use Current Server |
Select False to select a server for the synonym other than the current server. |
Server |
Enter the server name for the synonym. This field is enabled when you select False in the Use Current Server field. |
Object |
Select the name of the object on which you want to apply this synonym. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center