select name from syscolumns where id = object_id ( ' 表名 ' ) 下面这样也可以: select column_name from information_schema.columns where table_name = ' news ' 转载于:https://www.cnblogs.com/zhuboxingzbx/archive/2007/09/03/880049.html