Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step

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.