Results 1 to 2 of 2

Thread: Max. Columns & Foreign Keys

  1. #1
    Join Date
    Jul 2006
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Max. Columns & Foreign Keys

    How many maximum columns we can add in one table and how many maximum foreign keys we can use in one table?

  2. #2
    Join Date
    Sep 2005
    Location
    India
    Posts
    1,626
    Thanks
    6
    Thanked 107 Times in 107 Posts

    Thumbs up

    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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •