Click here to Skip to main content
15,888,610 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Working in ASP.NET.

In designing a new SQL Database,in 'Table.Colum' I get the Entry to be Filled in, 'IsIdentity?' What does this mean, and what are the long term consequences of setting it to either 'FALSE' or'TRUE'


Regards,


Bram :)
Posted
Updated 23-Jun-11 14:09pm
v2
Comments
Christian Graus 23-Jun-11 20:09pm    
I changed your tag, your question has nothing to do with ASP.NET, it's about SQL.

1 solution

OK, I assume you're just working for your own pleasure and not at work ?

An identity column is one that is auto generated. You specify the starting index and the amount to add each time, typically these are 1 and 1, so when you insert data, you can't specify these values, they just auto increment. So, the long term result is, you have an id that uniquely identifies each record, which you cannot ever change or set.

http://www.sqlteam.com/article/understanding-identity-columns[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900