Physical Modeling › Teradata Physical Property Editors › Define Teradata Views

Define Teradata Views

You can use the View editor to create new views and to modify properties for existing views for Teradata physical models.

To define Teradata database views

1. Click Database Views on the Model menu.

   The View Editor opens.

2. Select a view and work with the following options:

   Note: Click New on the toolbar to create a new view.

   Name

   Specifies the name of the view.

   Database

   Specifies the database or user to which the view belongs. Select from the drop-down.

   Use Replace Syntax

   Specifies if Forward Engineering will use the REPLACE command instead of the CREATE command.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Work with the following fields on the General tab:

   Select Top Percent

   Specifies the percentage of the rows to return from the select operation.

   Select Top Rows

   Specifies the number of rows to return from the select operation.

   Select With Ties

   Select to specify that all qualified rows having the same value (must have ORDER BY defined) are to be included in the result set.

   Recursive

   Select to specify that the view is recursive.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Define the locking options for a selected view on the Locking tab
   • Specify the tables and columns to use with the selected view on the Select tab
   • Choose from a list of available tables to populate the Select tab on the From tab
   • Specify properties for the where clause on the Where tab
   • View and change a user-defined DDL statement on the User Defined SQL tab
   • View SQL code for a selected view on the SQL tab
   • Associate permissions with the selected view on the Permission tab
5. (Optional) Click the Comment tab and enter any comments you want associated with the view.
6. (Optional) Click the UDP tab to work with user-defined properties for the view.
7. Click Close.

   The View Editor closes.

More information:

Define the Locking Options for a Teradata View

Select the Tables and Columns for the View or Join Index

Define User Defined SQL Code

View SQL Code for a Physical Object

Add Permissions in a Teradata Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor