1SELECT DATA_TYPE
2FROM INFORMATION_SCHEMA.COLUMNS
3WHERE
4 TABLE_NAME = 'yourTableName' AND
5 COLUMN_NAME = 'yourColumnName'
1SELECT COLUMN_NAME,
2 DATA_TYPE,
3 IS_NULLABLE,
4 CHARACTER_MAXIMUM_LENGTH,
5 NUMERIC_PRECISION,
6 NUMERIC_SCALE
7FROM INFORMATION_SCHEMA.COLUMNS
8WHERE TABLE_NAME='your_table_name';