在myql sqlserver 快速找到带有关键字的表

erqe211

sql server 全部库：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

declare @i int,@id int,@dbname varchar(255),@sql varchar(255)     set @i = 6     set @id=(select count(*) from master..sysdatabases) drop table #t create table #t (     dbname varchar(255),     tablename varchar(255),     columnname varchar(255) ) while (@i < @id)     begin         set @i = @i + 1;         set @dbname = (select name from master..sysdatabases where dbid= @i)         set @sql = 'use '+ @dbname+';insert [#t] select table_catalog,table_name,column_name from information_schema.columns where column_name like ''%pass%'' or column_name like ''%pwd%'' or column_name like ''%mail%'''         exec (@sql)         --print @sql     end select * from #t drop table #t go

sql server单个库：

1	SELECT sysobjects.name as tablename, syscolumns.name as columnname FROM sysobjects JOIN syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.xtype = 'U' AND (syscolumns.name LIKE '%pass%' or syscolumns.name LIKE '%pwd%' or syscolumns.name LIKE '%first%');

mysql：

1	select table_schema,table_name,column_name from information_schema.columns where table_schema !=0x696E666F726D6174696F6E5F736368656D61 and table_schema !=0x6D7973716C and table_schema !=0x706572666F726D616E63655F736368656D61 and (column_name like '%pass%' or column_name like '%pwd%');