At 09:48 AM 3/6/2002 -0600, Antonio Natividad wrote:

>Thaks but, How many Foreign Keys can I
>create in a table?
>
>65, 536??

Many fewer and the number depends on the page
size. Every foreign key creates an index and
every index is stored on the index root page
for the table. When the index root page is
full, you can't define any more indexes and if
you can't define an index, you can't define a
foreign key.


Regards,

Ann
www.ibphoenix.com
We have answers.