一个数据库中50个表，能否用sql查询出那些表中含有dw的字段

[fzdcn]

一个数据库中50个表，能否用sql查询出那些表中含有dw的字段

[fzdcn]

select * from user_tables where colum_name='dw'

colum_name is wrong

[liuyi8903]

select * from sys.all_tab_columns t WHERE t.column_name='DW'

[yown]

select table_name from all_tab_columns where column_name='DW';

[bluelamb]

select * from user_tables where colum_name='dw'