SQL Server

Primary Key in SQL Server

A primary key in SQL Server is a field (or combination of fields) in the table that uniquely identifies each row or record. In this tutorial let us learn what is a Primary key. We will learn how to create a Primary Key constraint. Learn to add or drop the Primary key from an existing table. We also look at how to change the primary key index from clustered to non clustered and also change the sort order from ascending to descending etc.

Primary Key in SQL Server Read More »

Scroll to Top