We have a table that we are going to recreate on partition scheme. Its clustered index is a primary key.
1. Can I just drop index without dropping the primary key ?
2. In case if the above is impossible, what the best way to overcome the problem with foreign keys created on other tables from our primary key ?
Should I drop them and re-create ? I tried to disable, but it does not work.
In a short, what is the best practice and sequence of steps in partitioning a table ?
Note: we already have partition function, scheme, filegroups. And some other tables are also partitioned.
Thanks