If you need to find out which table in a database has a certain column, you can use something like this:
select
(select name
from sys.tables
where object_id = columns.object_id), *
from sys.columns
where name = 'MyColumnName';
Does that help?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon