Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Oct 2015 @ 21:39:29 GMT


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


Subj:   Dropping Primary Index
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, October 02, 2015 11:13 -->

Hi,

Is it possible to drop PI from an empty table in Teradata, then load data to it and then build the Primary index on the table ?

I have not tried it out. But I think this is not possible and to do that we need to drop the table first, recreate it with the NO Primary Index clause, load the data and then add PI to it ?


Please advise.

Thanks



     
  <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: 27 Dec 2016