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

Chapter 11: Views: Limiting Access to Data

Listing all views in a database

sp_tables lists all views in a database when used in the following format:

sp_tables @table_type = "’VIEW’"



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

View this book as PDF