Physical Modeling › Teradata Physical Property Editors › Define Teradata Views › Define a Teradata View Column Expression

Define a Teradata View Column Expression

After you have specified view columns in the Teradata View Editor, you can define a view column expression, which is a user-defined expression that is stored as a view column.

To define a Teradata view column expression

1. Click Database Views on the Model menu.

   The Teradata View Editor opens.

2. Click the Select tab.

   The Select tab opens.

3. Click the New button.

   The New View Column dialog opens.

4. Enter information in the following fields and then click OK:

   Alias

   Lets you enter the name of the view column expression.

   Expression

   Lets you enter the view column expression.

   The view column expression is defined, the New View Column dialog closes, and you are returned to the Teradata View Editor.

5. Click Close.

   Your changes are saved and the Teradata View Editor closes.