/SQL/Find tables with column name in sql

Find tables with column name in sql

SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- Other schemas
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- All tables

Similar codes

16 votes153 views1 answer
Mysql reset auto increment value
SQL
5 votes176 views1 answer
Oracle create table comment
SQL
0 vote191 views2 answers
How to truncate all table in mysql workbench
SQL
53 votes445 views6 answers
Sql server alter column
SQL
0 vote155 views1 answer
Sql server select value large text
SQL
0 vote160 views1 answer
Oracle archivemode
SQL
1 vote178 views1 answer
Mysql select all and rename one
SQL
2 votes164 views2 answers
Spring where to put the data sql
SQL
0 vote143 views1 answer
First Step in installing SQL workbench
SQL
1 vote172 views1 answer
Psql connect to another database
SQL