1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

PersonID or Persons???

Discussion in 'SQL PL/SQL' started by monkey, Jun 3, 2014.

  1. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    I don't understand this in tutorial:

    http://www.w3schools.com/sql/sql_unique.asp

    I wonder if the "uc_PersonID" is just the name, and if we can write anything instead of it?

    LIke: "uc_BigBen":d- or is it connected with the name of the table?

    Many thanks!
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    No, it's just a name.
    Question of good practice: "uc" - for unique constraint followed by "Person_ID" the column name; you know immediately without looking into the data dictionary that this object is a unique constraint based on "PersonID"