Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

SQL Query to Create a View in Teradata

Teradata+Jobs

Simple Sql Query to create a view in Teradata:

CREATE View Employee_V AS
SELECT      Employee_No
           ,First_Name
           ,Last_Name
           ,Dept_No
FROM Employee_Table ;

- A view we create to Restrict Access to certain columns
-To Restrict access to certain derived columns
-To restrict access to join tables
-To restrict access to certain rows

View is basically in a semantic layer. It supports to Presentation layer. Some time a view can change column names, a view can derive new columns , also aggregate columns.

Simple rules for views:

- A view should not contain Order By
-All aggregate columns must have ALIAS
-All derived column must have ALIAS





This post first appeared on SriniTera - Data Analysis Solutions, please read the originial post: here

Share the post

SQL Query to Create a View in Teradata

×

Subscribe to Srinitera - Data Analysis Solutions

Get updates delivered right to your inbox!

Thank you for your subscription

×