RENAME PRIMARY INDEX

Database
N/A

RENAME PRIMARY INDEX

Does anyone have the exact syntax of the ALTER TABLE statement that can be used to rename a primary index?

 

Just a rename.... I'm not changing the primary index definition.

 

Thanks for you help!


Accepted Solutions
N/A

Re: RENAME PRIMARY INDEX

I played around until I figured it out.   In case anyone else needs to know....

 

alter table databasename.tablename
modify primary index new_index_name (existing index columns);
 

1 ACCEPTED SOLUTION
1 REPLY
N/A

Re: RENAME PRIMARY INDEX

I played around until I figured it out.   In case anyone else needs to know....

 

alter table databasename.tablename
modify primary index new_index_name (existing index columns);