mysql> select table_schema,table_name,column_name from information_schema.columns where column_name like 'password' ;
Select *From sysobjects sWhere Exists(Select *From syscolumnsWhere ID = s.ID and name like '%user%')
-
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
-
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%'
);
-
select column_name
,
data_type
,
data_length
,
data_precision
,
data_scale from user_tab_columns
[
where
table_name
=
'表名'
and column_name like
'%大写列名%'
];
-
SELECT owner
,
table_name FROM all_tab_columns WHERE column_name LIKE
‘%
PASS
%’;