搜索数据库某列名

use 指定数据库;

select sysobjects.name as tablename,syscolumns.name as columnnamefrom syscolumns join sysobjects on sysobjects.id = syscolumns.idwhere syscolumns.name like '%此处为列名%'获得全部列名use xxDB;select sysobjects.name as tablename,syscolumns.name as columnnamefrom syscolumns join sysobjects on sysobjects.id = syscolumns.id