Post reply

find the views dependency on other views

  • October 3, 2010 at 11:49 pm

    #224701

    Hi,

    I have a query to find the views dependency on other views:,

    Here I have a table of 3 columns(100+ rows). first column view name(100+ different views). second column dependency (either table or view) and third column dependency type T for Table and V for View.

    Purpose: in order to create the script, we need to put them in order of dependency, other wise the script will fail saying that the OBJECT (the view on which it depends) DOES NOT EXIST

    Can anybody give me suggestions for above query

  • October 4, 2010 at 3:38 am

    #1230879

    Please don't crosspost. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic997349-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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