Get PK column Name for a table

Get PK column Name for a table

DECLARE @destTbl varchar(100) = 'Account'

 SELECT i.name AS IndexName, OBJECT_NAME(ic.OBJECT_ID) AS TableName, COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName

   FROM sys.indexes AS i

  INNER JOIN sys.index_columns AS ic

        ON i.OBJECT_ID = ic.OBJECT_ID

        AND i.index_id = ic.index_id

  WHERE i.is_primary_key = 1

    AND OBJECT_NAME(ic.OBJECT_ID) = @destTbl

--DB