/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

0 vote106 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote113 views1 answer
Str_to_date sql server
SQL
0 vote101 views1 answer
Restore backupfile discourse
SQL
0 vote107 views1 answer
Postgresql regular expression special characters
SQL
3 votes133 views1 answer
Oracle function
SQL
0 vote96 views1 answer
VSCode SQL Server Connection error
SQL
0 vote118 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote116 views1 answer
How to remove quotes from a string in ssis load file
SQL
3 votes114 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
2 votes108 views1 answer
Mysql Incorrect column specifier for column
SQL