Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Depedencies between SQL Server Views

Author  Topic 

rajuarien1
Starting Member

2 Posts

Posted - 2008-01-18 : 11:28:45
How to find dependencies between SQL Server Views

Lets say a View A refers to View B and View B refers to View C. I want a way to determine, the order of creating this views, in this case,

View C
View B
View A.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-01-18 : 12:47:14
have a look at the system procedure sp_depends....it may help you in this regard.
Go to Top of Page
   

- Advertisement -