<div>
<div class="content wysiwyg-content">
Can I make an Identity column in a table a primary key plus make its associated tables have a primary key/Foreign that is an identity also?<br />
If so, can I cascade delete or cascade update on an identity column?
</div>
</div>


Can I make an Identity column in a table a primary key plus make its associated tables have a primary key/Foreign that is an identity also?
If so, can I cascade delete or cascade update on an identity column?

Sql server Identity usage

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.