title: Modifying Primary Index of a table in Teradata
body: <p>I am new to Teradata.
  I have a table with around 45k records with a particular Primary index.
  I want to change the primary index of this table.
  Can somebody help pls?</p>
  
  <p>Below is my current primary index.</p>
  
  <pre><code>PRIMARY INDEX IDX_NON_RTL_SALES_WIDE_01 ( col1 ,Col2 ,Col3 );
  </code></pre>
  
  <p>I want to remove col3 and add few other columns to it.</p>
  
  <p>Thanks in Advance</p>