How to find a table

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 1

SELECT object_name(object_id)

FROM sys.columns

WHERE name = 'WS_ID'

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 2

And, there's a free tool from Red Gate Software called SQL Search[/url] that can help with this kind of thing.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt