Q
Problem solve Get help with specific problems with your technologies, process and projects.

Using the identity column

Is it a good pratice to use the identity column on all the tables in an application? Where can I find some documents that tell where to use the identity and where not to use the identity column?

In general, it is a good practice to use an identity to key a table with a value which has no business meaning and is only used to relate tables together. However, this doesn't mean you use one in every table. My very simple database design lesson is the following:

"Put the data where it belongs"

Once you are finished designing your database to those principles, you are probably finished designing your database. No, it isn't much more complicated than that.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close