Using sp_depends to list dependent objects  Finding an object name and ID

Chapter 12: Views: Limiting Access to Data

Listing all views in a database

sp_tables lists all views in a database when used in this format:

sp_tables @table_type = "’VIEW’"



Copyright © 2011. Sybase Inc. All rights reserved. Finding an object name and ID

View this document as PDF