If you work with relational databases, you probably know that each table needs a primary key. But what is the purpose of a primary key and how does it help you manage your data?

To modify a primary key To modify a PRIMARY KEY constraint using Transact-SQL, you must first delete the existing PRIMARY KEY constraint and then re-create it with the new definition. For more ...