Sometimes you need to find a field and don't know what table or view it might be coming from. A very useful script to pull out:
SELECT b.name, c.name FROM sys.schemas a JOIN sys.all_objects b ON b.schema_id = a.schema_id JOIN sys.columns c ON c.object_id = b.object_id WHERE c.NAME LIKE '%Find Field%'
No comments:
Post a Comment