SQL statement to get column type

Question

Is there a SQL statement that can return the type of a column in a table?

Answer 1

 For SQL Server, try using this code:

SELECT DATA_TYPE 

FROM INFORMATION_SCHEMA.COLUMNS

WHERE 

TABLE_NAME = 'yourTableName' AND 

COLUMN_NAME = 'yourColumnName'