Chapter 3 Building Physical Diagrams

Assigning a default to a column or a domain

You can select a default from the list of defaults and assign it to a column or a domain from the Standard Checks tab of the column or domain property sheet.

For more information on check parameters, see Check Parameters (PDM).

If you only type a value in the Default list of a domain property sheet, it will not be generated as a default object in the database. It is highly recommended to use the Rebuild Default feature to create the default object corresponding to this value.

For more information, see section Rebuilding defaults.

Steps To assign a default to a column or a domain:

  1. Open the property sheet of a column or a domain, and click the Standard Checks tab.
  2. Select a default in the Default list in the Value groupbox.

    Alternatively, you can type a default value in the listbox; this does not create a default object in the model, it only assigns a default value for the current column or domain. If you type a name that already exists in the list, the default object is attached to the column or domain.
  3. Click OK in each of the dialog boxes.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.