摘要:
例子:SELECT a.name,b.name,a.length,e.text FROM syscolumns a left join systypes b on a.xusertype=b.xusertype left join syscomments e on a.cdefault=e.id WHERE a.id=object_id('table1') ORDER BY a.colidSQL Server数据库中表结构信息SELECT 表名 = case when a.colorder=1 then d.name else '' end, 表说明 = cas 阅读全文