I have some tables that we want to partition on a date column which is not the primary key. I kept getting error message "Partition columns for a unique index must be a subset of the index key." So I added the date column to the primary key. Now I can't recreate the foreign key because foreign key has to include all columns of the primary key and it doesn't make sense to include the date column in the foreign key.
- Primary Key - is an identity column
- Foreign Key wants to reference the Primary key (identity column only)
- Partition should be on a date column