Archives of the TeradataForum

Message Posted: Mon, 03 Apr 2006 @ 15:41:13 GMT

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

Hi,

To get the Primary index on a table created using create select use following syntax:-

     create table  as
     ( Select
        col1,col2,col3
     from table a ) with data primary index(col1) ;

Regards,

Rachana

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