This article is tagged with: Sql query to get column data type in sql and mysql

sql query to get column data type in sql

SELECT DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'yourTableName' AND
COLUMN_NAME = 'yourColumnName'


This article is tagged with: Sql query to get column data type in sql and mysql