Tuesday, November 22, 2011

Update an INDEX in sql

we can use ALTER INDEX command to modify then name of index on table.Here i will show how to change the name of Employee_phone to Employee_phone_number

Query:
ALTER INDEX Employee_phone RENAME TO Employee_phone_number;

No comments:

Bel