Updating partition statistics  How views work


Chapter 11: Views: Limiting Access to Data

A view is a named select statement that is stored in a database as an object. A view allows you to display a subset of rows or columns in one or more tables. You use the view by invoking its name in other Transact-SQL statements. You can use views to focus, simplify, and customize each user’s perception of the tables in a particular database. Views also provide a security mechanism by allowing users access only to the data they require.





Copyright © 2005. Sybase Inc. All rights reserved. How views work

View this book as PDF