Viewing 5 posts - 1 through 6 (of 6 total)
ALZDBA (7/11/2008)
ALTER TABLE your_partitioned_table
DROP CONSTRAINT PK_ ... '_constraintname
Yes! This is what I was looking for! I just missed the drop...
July 17, 2008 at 7:29 am
John Rowan (7/9/2008)
You've never said why you need to remove the keys? A bit of background on the end result you are trying to achieve would help.
The result I...
July 11, 2008 at 3:33 am
Well I have to drop the whole partioning or I have to delete the partition function and it depending partition scheme so afterwards I can remove the primary keys on...
July 9, 2008 at 8:22 am
Mucho gracies for the replies... I am pretty new to SQL so I was wondering if there is a easy (free, without purchasing tools) way to remove the partioning...
I still...
June 13, 2008 at 7:48 am
Viewing 5 posts - 1 through 6 (of 6 total)