I am trying to restore a backup of a Microsoft Dynamics NAV database, which unfortunately fails as it tries to set a CLUSTERED KEY for the tables which already have clustered keys.
In NAV, every company in the database gets its own copy of the tables, prefixed with the Company's name, e.g. COMPANY$User_Setup
. I'd therefore like to remove any clustered key on a given company, which means on any table which name starts with 'Company$'.
Has anybody got a SQL statement that could perform this?
Thanks in advance!
Best regards, Martin