|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > Maximum of foreign keys/references allowed in SQL Server 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Maximum of foreign keys/references allowed in SQL Server 2000
|
|
| Hugo Nheu 2002-12-10, 10:24 am |
| Hi there,
Does anyone know how many foreign keys can one table have?
And one table can be referenced how many times?
I've looked on BOL and it says 253 for each of the questions, however I only
found this after I had more than 300 relationships in several tables.
Until now I haven't had any kind of problems nor I have found (MSDN,
newsgroups,...) anyone who complains about this.
Your answers will be appreciated,
Hugo
| |
|
|
my 2 cents:
opinion: with that many FK, you have a design problem
fact: with that many FK, you'll most probably have performance problems (on
insert-update at least).
fact & opinion: the limit is indeed 253, but I don't know if it is enforced
correctly as this number is academic. You should never reach it.
Eric
"Hugo Nheu" <Hugo.Quaresma@datamex.pt> wrote in message
news:uIIYDRGoCHA.1608@TK2MSFTNGP08...
> Hi there,
>
>
>
> Does anyone know how many foreign keys can one table have?
>
> And one table can be referenced how many times?
>
>
>
> I've looked on BOL and it says 253 for each of the questions, however I
only
> found this after I had more than 300 relationships in several tables.
>
> Until now I haven't had any kind of problems nor I have found (MSDN,
> newsgroups,...) anyone who complains about this.
>
>
>
> Your answers will be appreciated,
>
>
>
> Hugo
>
>
>
| |
| Jason Hood 2002-12-10, 11:23 am |
| > fact & opinion: the limit is indeed 253, but I don't know if it is
enforced
> correctly as this number is academic. You should never reach it.
>
> Eric
Agreed. Definately.
Jason
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.427 / Virus Database: 240 - Release Date: 06/12/2002
|
|
|
|
|