sql query to get column data type in sql
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE FROM 'your_database_name'.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='your_table_name';
Source: www.google.com