Professional Web Applications Themes

Look up Tables - Microsoft SQL / MS SQL Server

Do you relate look-up table in sql server 2000? Example: MEMBER TABLE STATE TABLE MemberID StateID State State Would you relate these two table if you only need the state table to serve as a drop down list of states to compliment the members table? Please explain.Thank you!...

  1. #1

    Default Look up Tables

    Do you relate look-up table in sql server 2000?

    Example:
    MEMBER TABLE STATE TABLE
    MemberID StateID
    State State

    Would you relate these two table if you only need the state table to serve
    as a drop down list of states to compliment the members table? Please
    explain.Thank you!


    Leon Shaw Guest

  2. #2

    Default Re: Look up Tables

    In SQL, relationships are defined with a FOREIGN KEY constraint:

    CREATE TABLE States (statecode CHAR(2) PRIMARY KEY, statename VARCHAR(20)
    NOT NULL UNIQUE)

    CREATE TABLE Members (memberid INTEGER PRIMARY KEY, statecode CHAR(2) NOT
    NULL FOREIGN KEY REFERENCES States (statecode))

    > Would you relate these two table if you only need the state table to serve
    > as a drop down list of states to compliment the members table? Please
    The purpose of defining a foreign key constraint is to maintain Referential
    Integrity. In this case the foreign key ensures that members must have a
    valid statecode and that each state in the Members (child) table appears in
    the States (parent) table.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Portas Guest

Similar Threads

  1. Tables - do we really need them?
    By henryd in forum Macromedia Dynamic HTML
    Replies: 11
    Last Post: March 4th, 07:18 PM
  2. SQL tables help
    By al_galiza in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: June 29th, 01:45 AM
  3. Again tables!
    By Discover@adobeforums.com in forum Adobe Indesign Windows
    Replies: 6
    Last Post: June 4th, 04:32 PM
  4. My tables have gone??
    By Thanatos in forum Macromedia Fireworks
    Replies: 0
    Last Post: October 13th, 07:08 PM
  5. SQL tables
    By MSM in forum PHP Development
    Replies: 2
    Last Post: September 19th, 12:28 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139