Using sp_helptext to display view information  Listing all views in a database

Chapter 11: Views: Limiting Access to Data

Using sp_depends to list dependent objects

sp_depends lists all the objects that the view or table references in the current database, and all the objects that reference that view or table.

sp_depends titles 
Things inside the current database that reference the object. 
object               type 
-------------        --------------------------- 
dbo.history_proc     stored procedure
dbo.title_proc       stored procedure
dbo.titleid_proc     stored procedure
dbo.deltitle         trigger
dbo.totalsales_trig  trigger
dbo.accounts         view
dbo.bookview         view
dbo.categories       view
dbo.hiprice          view
dbo.multitable_view  view
dbo.titleview        view
 
(return status = 0) 




Copyright © 2005. Sybase Inc. All rights reserved. Listing all views in a database

View this book as PDF