Sp_pkeys is part of Catalog Stored Procedures and returns primary key information for a single table in the current database. Sytax for Sp_pkeys is
sp_pkeys [ @table_name = 'Table name.' ]
