How can we find how many tables are going to be associated with the same column name using SQL Query?
Can anyone help me with this?
Loading
2 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
You can find like this also in SQL Server.
- SELECT Table_Name, Column_Name
- FROM INFORMATION_SCHEMA.COLUMNS
- WHERE TABLE_CATALOG = 'YOUR_DATABASE'
- AND COLUMN_NAME LIKE '%YOUR_COLUMN%'
- SELECT owner, table_name, column_name
- FROM all_tab_columns
- WHERE column_name LIKE '%YOUR_COLUMN_NAME%'
- AND OWNER IN ('YOUR_SCHEMA_NAME');
Jay Krishna ReddyPosted Aug 6, 2020, 8:49 AM