Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 VIEW

Author  Topic 

Amber_Deslaurier
Starting Member

40 Posts

Posted - 2010-06-21 : 19:31:15
Hi Experts :)

How do I create a VIEW from my tables in TERADATA? Is it something like this?

CREATE VIEW AS VIEW_NAME (

SELECT.... joins... etc

) ON DATA PRESERVE ROWS

???

Thanks guys!

Amber

Sachin.Nand

2937 Posts

Posted - 2010-06-21 : 23:20:29
There is nothing like "ON DATA PRESERVE ROWS" in SQL Server.Rest of the syntax is right.


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page
   

- Advertisement -