在myql sqlserver里边怎么快速找到带有关键字的表
时间:2022-03-14 10:47
sql server 全部库:
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,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%‘);
在myql sqlserver里边怎么快速找到带有关键字的表,布布扣,bubuko.com