I've got a large fact table that contains a TimeStamp column and an ID column.ÃÂ ÃÂ The table is partitioned on the TimeStamp column.ÃÂ Up until now it has never had a Primary Key.ÃÂ However, now I would like to create a PK on the ID column, because I am building another table that has a FK that references the ID column of my existing table.
And it looks like I can't.
I can't addÃÂ a PK or Alternate Key to the partitioned table unless the key includes the partitioning column.ÃÂ ÃÂ If I include the Partitioning column in the Key, I have to include it in the FK of the other table, which isn't an option.. at least, not one I'm willing to take.
Please tell me there's a work-around for this, somebody... I already know that I could enforce RI by other means;ÃÂ but I'm hoping for a work-around that allows me to put a PK on this partitioned table.
View Complete Post