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

Page 1 of 1

## 0 Replies - 12329 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=890db15cd1d984cdfe2391f7e3b8a328&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: 949
• Posts: 2,361
• 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; }