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

sql server 全部库：

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单个库：

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：

select?table_schema,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%');

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!