Skip to content
Advertisement

Renaming index gives error Explicit @objtype id not recognised

I am trying to rename an index and getting an error:

Error: Explicit @objtype ‘idx_FinData20’ is unrecognized.

I can see both the table and index exist. Then what is the problem

Advertisement

Answer

First – your syntax is wrong. You need only two arguments, first should be table_name.old_name and second one is just new name. Second – you have an extra space in your new index name which breaks the script.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement