Archives of the TeradataForum

Message Posted: Sun, 04 Oct 2015 @ 11:21:45 GMT

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

Hi Sankar,

The rules around adding / removing / changing the PI are very simple.

If the table ** HAS NO DATA ** in it you can make any of the changes listed above.

If the table ** HAS DATA ** in it you can NOT make any of the changes listed above.

You have to work within those rules.

To specifically answer your questions below:

" So In other words I can not insert data into a table after the PI is dropped. Or I have to recreate the table with NO PRIMARY INDEX clause." - Not really. If you 'drop a primary index' you have to replace it with something (a different PI or make it a NOPI table). Data can be inserted into the table.

" If a table is built with No Primary Index clause, is it possible to add a PI to this table with data in it ?" - NO - as per the 'rules' that I listed above.

I hope that helps.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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