find the views dependency on other views:

• Nagaram

  SSCrazy

  Points: 2110

  More actions

  October 3, 2010 at 11:43 pm

  #241210

  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

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  October 4, 2010 at 1:11 am

  #1230845

  Duplicate post . Answer on this link http://www.sqlservercentral.com/Forums/Topic997349-146-1.aspx

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)