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:
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?