Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 16:28:19 GMT

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

Show table tablea; (keep ddl)

Create tableb....(change index);

Insert into tableb Select * from tablea;

Drop table tablea;

Rename tableb to tablea;

I think have to be careful that if you have any specific rights on tablea (such as index rights)for anyone other than the owner/creator, you may have to re-grant those rights. You may want to check these rights before dropping tablea.

KRT

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