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

发布时间：2020-12-12 13:50:29 所属栏目：MsSql教程来源：网络整理

导读：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? varchar (255),@sql? (255) ???? set ? @i?=?6 @id=( select ? count (*)? from ? master..sysdatabases) ? drop ? table ? #t create ? #t?(

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?varchar(255),@sql?(255)????set? @i?=?6@id=(select? count(*)?from? master..sysdatabases) ? drop? table? #tcreate? #t?(????dbname?tablename?columnname?(255)) ? while?(@i?<?@id)begin????????@i?=?@i?+?1;@dbname?=?(select? name? master..sysdatabases?where? dbid=?@i)@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%''%mail%'''exec? (@sql)????????--print?@sqlend ? select? *?#t#t ? go

sql server单个库：

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

mysql：

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

（编辑：李大同）

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

sql server 全部库：