473,326 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Does SQL Server 2000 support foreign key in partitioning?

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
6 2013
ck9663
2,878 Expert 2GB
Yes. It's called FOREIGN KEY Constraints

-- CK
Feb 17 '09 #2
SLauren
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
2,878 Expert 2GB
Yes. Once enabled, you can not drop a parent record if it's being referenced by a child record.

-- CK
Feb 18 '09 #4
SLauren
60
Thanks a lot for the reply ....

Regards,
Lauren
Feb 18 '09 #5
SLauren
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
2,878 Expert 2GB
Before we proceed, would you mind explaining what your definition of partitioning is?

-- CK
Feb 18 '09 #7

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

Similar topics

0
by: Jerry Brenner | last post by:
Our users have potentially dirty legacy data that they need to get into our application. We provide a set of staging tables, which map to our source tables, that the users do their ETL into. ...
9
by: Fernand St-Georges | last post by:
Hi, can someone tell how to write a Trigger; I am familiar with Sybase Sql Anywhere trigger syntax. Actually I have three tables MEMBER, CONTRACT and PAYMENT I need to update the MEMBER.BALANCE...
13
by: Jeager | last post by:
Why is it, Microsoft manage to write operating systems and office applications with every bell and whistle facility known to man. Yet, even after years and years of development they still cannot...
3
by: . . | last post by:
Hi I am creating new SQL Server Tables using SQL Server 2005. I have set primary key to the tables .But I do not know how to assign Foreign key to the tables .I need to do some joins later and...
4
by: harish | last post by:
DELETING 100 million from a table weekly SQl SERVER 2000 Hi All We have a table in SQL SERVER 2000 which has about 250 million records and this will be growing by 100 million every week. At a...
12
by: Frank Hauptlorenz | last post by:
Hello Out there! I have a DB2 V7.2 Database (Fix11) on Win 2000 Professional. It was before a NT 4 based Domain - now it is a Win 2000 Domain. The database server is a domain member. Now...
6
by: shaun.mostashari | last post by:
Hello all, I am curious to know if anyone has done a trade study on DB2, SQL Server, and Oracle databases. Basically I am trying to identify which one to chose based on "Ease of implementation",...
6
by: Susanne Klemm | last post by:
Hi! I have a table with a check constraint. But unfortunately it does not work like I wanted. CREATE TABLE MAP ( NOT NULL, NULL,
1
by: Zeljko Bilandzija | last post by:
Hello! I have a problem, and I looking for help if someone can handle this. I use asp.net 2.0, and I create web site which support users from internet (Web Site Administration Tool) and with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.