Change Primary Key

[Alfredomulet]

Hello there,
Can I change the primary index of a table using the ALTER function? Using create and insert into again takes too long to process.

Thanks

Alfredo G. Mulet
StrConsult
Los Samanes, 10
Caracas,
Venezuela

 

[tdgulbra]

No. You can not alter the primary index of a Teradata table. The only option to change a primary index is to re-create the table.

Tony