Example: Adding a Name to a Previously Unnamed Primary Index - Advanced SQL Engine - Teradata Database

To name the primary index of the orders table defined in Table Definitions for Examples, you could perform the following request:

     ALTER TABLE orders 
     MODIFY PRIMARY INDEX ordpi;