kaveer
8/29/2016 - 11:49 AM

View column in table

View column in table

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