Chapter 3 Building Physical Diagrams

Selecting a data type for a column

There are two ways to select a data type for a column:

• Attach the column to a domain - The domain dictates a data type, a length, and a level of precision, as well as optional check parameters
• Manually select a data type - You select a data type along with a length, a level of precision, and optional check parameters

To select a data type for a column:

1. Double-click a table to open its property sheet, and click the Columns tab.
2. Click the required column entry and then click the Properties tool to open its property sheet.
   
3. Select a data type from the Data Type list or click the Question mark button to open and choose a data type from the Standard Data Types dialog box .
4. If required, enter a data type length and precision.
   
   
      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 database, as defined in the DBMS.
   
   
5. Click OK in each of the dialog boxes.

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