SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length FROM syscolumns, systypes
WHERE syscolumns.xusertype = systypes.xusertype
AND syscolumns.id=
object_id('T_OA_WLWZ_DJB')sqlserver表结构查询语句,布布扣,bubuko.com
原文：http://blog.csdn.net/piaoxuan1987/article/details/33801833