select [name]as ColumnName from syscolumns where id in(SELECT id FROM sysobjects where [name]='AAA') 但是我程序中所用到的表前面都有dbo.作为前缀 ...