-
SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE,COLLATION_NAMEFROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MyTableName'