Chapter 3 Building Physical Diagrams


Selecting a data type for a domain from its property sheet

Steps To select a data type for a domain from its property sheet:

  1. Select Model→Domains to display the List of Domains.
  2. Click the domain to define.

    An arrow appears at the beginning of the line.
  3. Click the Properties tool.

    or

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

    The domain property sheet opens to the General page.
  4. Select a data type from the Data Type dropdown listbox.

    Note   Selecting a data type from a list of standard data types
    To select a data type from a list of standard data types, click the Question Mark button at the end of the Data Type dropdown listbox, and select the radio button for a data type from the list that appears.

  5. Type the maximum number of characters for the data item in the Length box.
  6. If the data type can include values that take a decimal point, type the number of places after the decimal point in the Precision box.
  7. Click OK.

    The change of data type appears in the List of Domains.

    Note   Undefined data type
    If you do not want to select a data type immediately, you can choose the <Undefined> data type. When you generate the database, this data type is replaced by the default data type for your target DBMS.




 


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