datatype intable daatbase ccheck code example
Example: datatype intable daatbase ccheck
SELECT DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'table_name' AND
COLUMN_NAME = 'column_name'
SELECT DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'table_name' AND
COLUMN_NAME = 'column_name'