select name from syscolumns where ID=OBJECT_ID('表名称') --默认返回该表的所有列的列名 转载于:https://www.cnblogs.com/luzx/archive/2011/04/22/2025014.html