Create table 1

[Souvik]

Is there a way to create a table in Teradta as a select statement in teradata, as there is in Oracle? If yes, what is the syntax?

Thanks!!

 

[tdatgod]

CREATE TABLE target_table AS
(SELECT .... )
WITH [NO] DATA;

WITH DATA -- Populate the table as well
WITH NO DATA -- only create the table.

 

[dnoeth]

The CREATE TABLE AS is Standard SQL, but you probably have to add a Primary Index, because the default is a NUPI on the first column and this may result in a skewed table:

create table foo as (any complex select) with data primary index (columnA, columnB);

Dieter

 

[prabhjot]

In addition to Dieter, you can add SET / MULTISET to check if you need multiple rows or not.