0

My Database tables looks similar to this one: Sample DB Diagram

I've partitioned table on TimeStamp in Logtable. This LogTabel is refenced by CHILD_TABLE WITH LogId.

Now, I want to perform Switch partition but getting below warning and not allowing me to perform an action:

Manage Partition Wizard

I tried to remove Non-Clustered Index on LogID but cannot do it without dropping all Foreign-Key relationships.

How can I get rid of this warning?

1 Answer 1

2

You have to drop the foreign keys and index. From BOL:

No foreign key from another table can reference the source table. The source table cannot be referenced by a foreign key in another table.

https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms191160(v=sql.105)?redirectedfrom=MSDN

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.