查询 某表的 全部列

SELECT name
FROM syscolumns
WHERE (id =
          (SELECT MAX(id) AS Expr1
         FROM sysobjects
         WHERE (xtype = 'u') AND (name = 'lis_inspection_sample')))

原文地址:https://www.cnblogs.com/tongdengquan/p/6090651.html