Cacher is the code snippet organizer for pro developers

USE staging;
GO
SELECT COLUMN_NAME ,
	  DATA_TYPE ,
	  IS_NULLABLE ,
	  COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TABLE_NAME';