Physical Modeling › Columns

Columns

When you add and maintain columns in a table, you must assign physical properties to the column including datatype, null option, defaults, validation rules, volumetrics, comments, user-defined properties, display properties, and even storage properties for some target servers. You can manage all column properties in the Columns dialog.

In addition to specifying column properties in the Columns dialog, you can also assign datatype, edit masks, and other column properties using the Domain Dictionary to define domains. A domain is a named set of column properties that you can attach to one or more columns in a model to quickly and accurately define their properties.

You can also review, move, copy, and modify columns using the Model Explorer.

Note: The unique name rules are not enforced for attribute and column names inherited from domains.

More information:

Add a Column to a Table

Create or Modify a Server Display Format

Define General Column Properties

Reset Column Properties to the Domain Defaults

Assign a Domain to a Column

Assign Default or Validation Constraints to a Column or Attribute

Add a Column to an Index

Columns Dialog

Specify a Column Data Warehouse Source

Define Teradata Display Format Options