Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Dropping Primary Index
From:   Dave Wellman

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.



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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023