SELECT syscolumns.name,systypes.name,syscolumns.length --,syscolumns.isnullable FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id(‘sgmaster‘)
sql 2005 数据结构查询
原文:http://www.cnblogs.com/cnby/p/3983608.html