Determine Primary Keys For Table In SQL Server 2008

In this article I will tell you how to determine tables having primary key in a database.
  • 2068

In this article I will tell you how to determine tables having primary key in a database. Primary key plays very important role as it is main entry way into your dataset, so that you are confirmed to affect one row of data.

Primary Key enforces uniqueness of the column on which they are defined. Suppose I want to drop primary key on one table but i do not know which table is having primary key. To determine what tables have primary keys, write following SQL statements.

TableHavingPrimaryKey.jpg

All the table having primary key are listed in output.
© 2019 DotNetHeaven. All rights reserved.