# [link] Explanation of Composite Primary Keys and Identity Column

Page 1 of 1

## 0 Replies - 12451 Views - Last Post: 13 November 2011 - 10:05 PMRate Topic: //<![CDATA[ rating = new ipb.rating( 'topic_rate_', { url: 'http://www.dreamincode.net/forums/index.php?app=forums&module=ajax&section=topics&do=rateTopic&t=255562&amp;s=3dac36ea3bc112c862769b145b4106d3&md5check=' + ipb.vars['secure_hash'], cur_rating: 0, rated: 0, allow_rate: 0, multi_rate: 1, show_rate_text: true } ); //]]>

• Changed Man With Different Priorities

Reputation: 962
• Posts: 2,380
• Joined: 15-February 11

# [link] Explanation of Composite Primary Keys and Identity Column

Posted 13 November 2011 - 10:05 PM

http://weblogs.sqlte...imary_keys.aspx

Quote

...he kept confusing primary keys with identity columns. They are not the same! An identity column may be a type of primary key, but a primary key is not an identity column; it is a set of columns that you define that determine what makes the data in your table unique. It defines your data. It may be an identity column, it may be a varchar column or a datetime column or an integer column, or it may be a combination of multiple columns.

Is This A Good Question/Topic? 0

Page 1 of 1

 .related ul{list-style-type:circle;font-size:12px;font-weight:bold;}.related li{margin-bottom:5px;background-position:left 7px!important;margin-left:-35px;}.related h2{font-size:18px;font-weight:bold;}.related a{color:blue;}