Archives of the TeradataForum
Message Posted: Fri, 06 Apr 2012 @ 13:45:37 GMT
What sort of differences are you thinking of?
The "create table as" syntax allows you to
- clone an existing table
- create a table based on the results of a SELECT
- populate the table with data
- copy existing stats from the source table (I think only if you clone a table)
The "create table as" syntax does not allow you to add RI constraints.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|