摘要：
select SO.name 表名,SC.name 表列名,SC.colid 索引,SC.length '大小',ST.name 类型from tempdb..sysobjects SO,tempdb..syscolumns SC,tempdb..systypes ST where SO.id=SC.id and SO.xtype='U' and SO.status>=0 and Sc.xtype=ST.xusertype and SO.name='##sssff'order by SC.colorder--非临时表去掉tempdb.. 阅读全文
