By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Does SQL Server 2000 support foreign key in partitioning?

P: 60
Hi,
Can anyone please suggest me whether SQL Server 2000 supports foreign key or not?

Let say i have two tables master and detail. I want to have horizontal partitioning on the master table and which is referenced by the detailed table. Can anyone please suggest me whether i can do this or not??

Thanks in advance....

Warm regards,
Lauren
Feb 17 '09 #1
Share this Question
Share on Google+
6 Replies


ck9663
Expert 2.5K+
P: 2,878
Yes. It's called FOREIGN KEY Constraints

-- CK
Feb 17 '09 #2

P: 60
Thanks for the reply.
Does sql server 2000 enforces any kind of restrictions while referencing the master table using foreign key constraint if we have a horizontally partitioned master table?

Thanks in advance....

Regards,
Lauren
Feb 18 '09 #3

ck9663
Expert 2.5K+
P: 2,878
Yes. Once enabled, you can not drop a parent record if it's being referenced by a child record.

-- CK
Feb 18 '09 #4

P: 60
Thanks a lot for the reply ....

Regards,
Lauren
Feb 18 '09 #5

P: 60
Can we be able to drop a partition from the master if it is referenced from the detailed table? Can i get any guidelines for horizontal partitioning with foreign key constraint on sql server 2000.

Thanks....
Regards,
Lauren
Feb 18 '09 #6

ck9663
Expert 2.5K+
P: 2,878
Before we proceed, would you mind explaining what your definition of partitioning is?

-- CK
Feb 18 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.