Post reply

getting where clause for views

  • June 27, 2005 at 10:58 pm

    #568811

    hi this query will result in all the views that depend on a table , something that can also be achieved by sp_depends <table name>

    wat we are looking for is get the substring of where clause when the specified table is participating and getting the exact where clause in that case

    i think it is not possible by sql and wud have to revert to string manipulation in .net

    thnx everybody for help

  • June 28, 2005 at 9:30 am

    #568984

    You'll be better off in .net. The string manipulation is much easier there.

Viewing 2 posts - 31 through 31 (of 31 total)

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