SQL SERVER – Show Primary Key for a Single Table – sp_pkeys

(Pinal Dave) When I work with Comprehensive Database Performance Health Check, I get all sort of questions and I love answering them. Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.

Register to Read