Chapter 3 Building Physical Diagrams

Attaching a column to a domain

If you attach a column to a domain, the domain supplies the data type and related data characteristics. It may also indicate check parameters, and business rules.

Steps To attach a column to a domain:

  1. Double-click a table in the diagram to display the table property sheet.
  2. Click the Columns tab.

    The Columns page appears listing columns associated with the table.
  3. Click a column in the list to display an arrow at the beginning of the line.
  4. Click the Properties tool.

    or

    Double-click the arrow at the beginning of the line.

    The column property sheet appears.


    Note   Opening property sheets at last accessed page
    Property sheets open to the General page by default. However, you can choose to open property sheets at the last page accessed by selecting Tools→Options→Dialog, and selecting the option Keep Last Tab in the Property Sheets groupbox.

  5. Select a domain from the Domain dropdown listbox at the bottom of the dialog box.
  6. Click OK.

    You return to the Columns page. In the Data Type column, the domain data type replaces the data type previously defined for the column.
  7. Click OK.

 

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