CODE EXAMPLE FOR SQL

mssql get data types of columns

SELECT 
	COLUMN_NAME
    ,DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_SCHEMA = 'yourSchemaName' AND
     TABLE_NAME   = 'yourTableName'