Previous Topic: Define Teradata Table Column PropertiesNext Topic: Rename a Column


Add Columns Using a Domain

To speed the process of defining physical column properties, you can group a set of column properties together in the Domain Editor and save them as a domain. You can quickly create columns in your tables by dragging and dropping domains from the Model Explorer to tables. Each new column you create in this way inherits all physical domain properties, including the column name. You can also assign domain properties to a given column simply by associating the column name with the domain name in the Table Column Editor. When you attach a domain to an existing column, you do not overwrite the column name with the domain name.

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

To add a column using a domain, drag the domain that you want to add to the table from the Model Explorer and drop it onto the table on the diagram. The domain's columns are added and display in the table on the diagram.