August 12, 2009 at 6:17 am
I have check No. of objects (stored procedures, views or functions) that each table is using in such a manner that it lists all Objects and in from of all objects it shows Tables aswell.
supports i have a table "media" and "mediaDetails"
there are found SPs for media table "spAddMedia, spUpdateMedia, spDeleteMedia and spGetMediaList"
similarly there are 6 SPs for mediaDetail which also used media table
spAddMediaDetails
spUpdateMediaDetails
spDeleteMediaDetails
spListMediaDetails
spSetMediaDetailsPath
spCheckMediExists
so the list will show like
SP
spAddMedia Media
spUpdateMedia Media
spDeleteMedia Media
spGetMediaList Media
spAddMediaDetails Media, MediaDetails
spUpdateMediaDetails Media, MediaDetails
spDeleteMediaDetails Media, MediaDetails
spListMediaDetails Media, MediaDetails
spSetMediaDetailsPath Media, MediaDetails
spCheckMediExists Media, MediaDetails
How to do this ?
Please help
Shamshad Ali.
August 12, 2009 at 6:58 am
i have fixed my query;-)
select object_name(id),
case when patindex('%Media%', [text]) > 0 then 'tbl_Mediaelse '' end as Media,
case when patindex('%MediaDetails%', [text]) > 0 then MediaDetails' else '' end as MediaDetails
FROM syscomments
where text like '%Media%' or text like '%MediaDetails%'
order by 1 desc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply