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 Views on the Model menu.

   The Teradata View Editor opens.

2. Click the Select tab.

   The tables and views available in the database are displayed in the Available Tables and Views section.

3. Click New.

   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.

More information:

Define View Columns