We can use the following query to find a list of tables that contain a specific column name in entire database.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='column name'
If you are unsure what is the exact column name , you can use the following query:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='column name'
No comments:
Post a Comment