Wednesday, August 4, 2010

Find a specific column in all database tables

following query can be used to find a specific column in all database tables

select table_name from information_schema.columns where column_name = 'Inactive'

No comments:

Post a Comment