Chapter 8 Quick Reference

To	Do This
Create a view in SQL Server Management Studio	Right-click the Views folder in the desired database. Choose New View. Add base tables used in the view. Select the columns to show.
Obtain information about views	Use the sys.views and sys.sql_modules system catalog views.
Access information about view dependencies in SQL Server Management Studio	Right-click the desired view. Choose View Dependencies.
Modify the view definition	Use the ALTER VIEW statement.
Update rows from a view	Make sure you update rows from only one table.
Bind the view to based tables	Use the schemabinding option.
Create a partitioned view	Create linked servers to access remote SQL Server instances. Create a view with a UNION operator to combine data from all of the instances. Create INSTEAD OF triggers to redirect operations.
Encrypt the view definition	Use the WITH ENCRYPTION option.