Programming Tips: How Column reference in all Tables in Sql Server

Thursday, 12 February 2015

How Column reference in all Tables in Sql Server



SELECT obj.Name SPName, sc.TEXT SPText

FROM sys.syscomments sc

INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID

WHERE sc.TEXT LIKE '%' + 'Email' + '%'

AND TYPE = 'P'

Related Searches : Query for Table Column reference in all Tables in Sql Server .

Kindly Bookmark and Share it:

1 comment:

zenolamonda3 March 2022 at 08:25
Harrah's Philadelphia Casino & Racetrack - MapyRO
Philadelphia is a racino with over 목포 출장마사지 1,100 slot machines and 정읍 출장샵 over 200 table games 경상북도 출장샵 with over 700 in-house poker 논산 출장안마 and table 태백 출장마사지 games. You can bet on sports and
ReplyDelete
Replies

Subscribe to: Post Comments (Atom)