SQL Server根据列名查表

select a.name, b.name from syscolumns a, sysobjects b where a.name = 'XXXX' and a.id = b.id andb.xtype = 'u'