SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: feature of primary key

  1. Feb 28, 2005 17:42 #1
    dotJoon
    dotJoon is offline
    Get my greedy down dotJoon's Avatar
    Join Date
    Apr 2003
    Location
    daejeon, South Korea
    Posts
    2,121
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    feature of primary key

    Is the primary key indexed and unigue by definition?

    If I have a column which should be indexed and unigue, do I have to make it primary key instead of indexed and unigue?
  2. Feb 28, 2005 18:00 #2
    ChrisHasenpflug
    ChrisHasenpflug is offline
    SitePoint Zealot
    Join Date
    Jun 2004
    Location
    Kansas City, MO
    Posts
    143
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes

    No
  3. Feb 28, 2005 19:29 #3
    r937
    r937 is online now
    SQL Consultant silver trophybronze trophy
     SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,453
    Mentioned
    34 Post(s)
    Tagged
    1 Thread(s)
    yes, it is

    no, you don't have to, but it would be a very good idea to do so
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"
« Previous Thread | Next Thread »

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
  •  

Forum Rules