在sql server中如何用sql语句查看表结构信息？

执行如下sql：

sp_help tablename;

再如：

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'APN_USER'

ORDER BY ORDINAL_POSITION

具体：

SELECT TABLE_NAME,COLUMN_NAME,DATA_TYPE

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'APN_USER'

ORDER BY ORDINAL_POSITION