mssql query field type

如何知道欄位的型態：

Using SQL Server:

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

Mysql 可以使用 show create tableyourTableName; 來取得