Table Search Based on the Column

Question

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

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

TravisDBA SSCoach Points: 15780 More actions · Answer 1

Actually, I like this query better. It's a little more efficient on the Column Name serach. 😀

SELECTST.name as [Table Name], SC.NAME as [Column Name]

FROMsys.tables ST (NOLOCK)

INNER JOIN

sys.columns SC (NOLOCK) ON ST.OBJECT_ID = SC.OBJECT_ID

WHERESC.name LIKE '%NAME%'

ORDER BY ST.name

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

Thanks for the insight. I have great use for this.