Skip navigation links

User Comments

Posted by Ferdous Khan on January 12 2012 6:47pm[Delete] [Edit]

ALTER TABLE sales.order ADD UNIQUE(order_ref);

This command will update 'sales' databases 'order' tables 'order_ref' column to become uniquely indexed. If the column already have some duplicate data, an error message will be prompted.