Find Data Base Table With Primary Key

SELECT  Tab.TABLE_NAME AS TABLE_NAME,
  COLUMN_NAME AS PRIMARY_KEY_COLUMN
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS Tab
  ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY'
  AND TC.CONSTRAINT_NAME = Tab.CONSTRAINT_NAME
  AND Tab.TABLE_NAME = 'TABLE'
ORDER BY Tab.TABLE_NAME,
Tab.ORDINAL_POSITION;