Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: What lookup tables for?

    Can you please explain with an example of heirarchy or usefulness how the lookup tables are useful in a database.

    Can the stored procedures used to populate the lookup table.

    Please answer me.

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1
    A lookup table is just a table whose principle purpose is to provide a "lookup" of valid values such as countries, statuses, shoe sizes or whatever; i.e. the kind of data that is generally created once and then remains static. They are useful for data validation and providing lists of values in applications.

    Yes, they can be populated by a stored procedure, or by a data entry form, or by import from a file, etc. - same as any other kind of data.

Posting Permissions

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