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.
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.
All the table having primary key are listed in output.