Specifying a Data Type for a Column

You can specify a data type for a column directly in its property sheet or via a domain, which can specify a data type, length, and a level of precision, as well as optional check parameters to indicate data ranges and validation rules. You can set check parameters for domains, tables, and columns.

  1. Open the property sheet of a column from the Columns tab of its parent table or from the column's Browser item under its parent table.
  2. 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 (see List of Standard Data Types).


  3. If appropriate, enter a data type length and precision.
    Note: 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.
  4. Click OK to save your changes.
Parent topic: Columns (PDM)