Creating a View - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
A view is a virtual table that you can use as a physical table to retrieve data defining columns from underlying views or tables, or both.
  1. In the Navigator, expand the Databases, right-click a database or user, and click Show Views. A list of the views defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer toolbar, click .

    A Create View property form opens in the Details view.

  3. In the form, enter values for the new view.
  4. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new view.
  5. Click Commit.
  6. Click OK. The property form shows the properties of the new view.