PDA

View Full Version : Max. Columns & Foreign Keys



real_estate
07-25-2006, 06:22 AM
How many maximum columns we can add in one table and how many maximum foreign keys we can use in one table?

codeexploiter
08-09-2006, 05:38 AM
Hi

It purely depends upon the database you are using. This differ from database to database. I mean the number of fields in a table.

We can have n number of foreign keys in a table theoritically. Practically rather it would be the total number of fields allowed in a table.

Though databases allows us to have large number of fields we used to reduce the number of fields for the sake of flexibility, consistency, concurrencry, etc.

We can apply Normalization principles on our tables and split a big table into a number of tables and relate them using foreign keys.

hope this will help you

Regards

Code Exploiter