Here is a follow up blog post of my earlier blog post on very similar subject Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys. In previous blog post we listed foreign keys and now we will list the primary key of the table with the help of Stored Procedure sp_fkeys. The stored procedure to use for primary keys is actually sp_pkeys.
Here is a quick script how you can use stored procedure sp_pkeys to list the primary key. This stored procedure takes a minimum of two parameters a) name of the table, b) name of the schema.
USE AdventureWorks2012;
GO
EXEC sp_pkeys @table_name = N'Employee',
@table_owner = N'HumanResources';
Here is the output generated from the script listed above:
Here is an alternate way to list the keys as well – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
1 Comment. Leave new
How do i get operating system information in sql server 2008?