Archives of the TeradataForum
Message Posted: Sun, 04 Oct 2015 @ 11:21:45 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|