find table in all my views - SQL Server Forums

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)

find table in all my views

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-04-15 : 03:12:22

how can i find table\view in all my views?

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2010-04-15 : 03:16:20

In the Object Explorer,
Right Click On your view, and click on "View Dependencies".
Now you can view the table/view names which your view depends.

Solutions are easy. Understanding the problem, now, that's the hard part

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-04-15 : 03:23:35

thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-04-15 : 08:32:43

or

EXEC sp_depends 'view_name'

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources