Encrypts the entries in sys.syscomments that contain the text of the CREATE VIEW statement.Using WITH ENCRYPTION prevents the view from being published as part of SQL Server replication.In addition, the OPENROWSET command can also support SELECT statements where a table is joined to the Excel spreadsheet.

A view does not have to be a simple subset of the rows and columns of one particular table.

A view can be created that uses more than one table or other views with a SELECT clause of any complexity.

All referenced objects must be in the same database.

Views or tables that participate in a view created with the SCHEMABINDING clause cannot be dropped unless that view is dropped or changed so that it no longer has schema binding. Also, executing ALTER TABLE statements on tables that participate in views that have schema binding fail when these statements affect the view definition.

Column names can also be assigned in the SELECT statement.

If Note In the columns for the view, the permissions for a column name apply across a CREATE VIEW or ALTER VIEW statement, regardless of the source of the underlying data.

Creates a virtual table whose contents (columns and rows) are defined by a query.

Use this statement to create a view of the data in one or more tables in the database.

SCHEMABINDING Binds the view to the schema of the underlying table or tables.