Modifying Primary Index of a table in Teradata
<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>