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!
Go to Solution.
I played around until I figured it out. In case anyone else needs to know....
alter table databasename.tablenamemodify primary index new_index_name (existing index columns);