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

Using SQL Server:

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