Cacher is the code snippet organizer for pro developers

USE staging;
GO
SELECT COLUMN_NAME ,
	  CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME = 'TABLE_NAME';

USE staging;
GO
SELECT TABLE_NAME,
   CONSTRAINT_NAME,
   CONSTRAINT_TYPE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS