Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 13:37:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Is it possible to set a PRIMARY KEY when I'm creating a table from a select statement?

Ex.:

     CREATE TABLE TEST
     AS (SELECT VAR1, VAR2, VAR3
     FROM TABLE) WITH DATA;

Where VAR1 should be the PRIMARY KEY.

Rgds

Cassiano

	<Prev	Next>		<<First	<Prev	Next>	Last>>