Thursday, April 16, 2009

Find tables that contain a certain field in database

Some times user need to get information about a table field,means how many table contains this field. A table field eg 'xyz' have relationship with many table and you want to see all table.Write below query.

select * from information_schema.columns where column_name = 'xyz'

Thanks & Regards
Santosh

0 comments:

Post a Comment