Page 73 - DCAP508_DATABASE_ADMINISTRATION

Unit 5: SQL Server Databases

You cannot associate rules or DEFAULT definitions with views. Notes
You cannot associate AFTER triggers with views, only INSTEAD OF triggers.
The query defining the view cannot include the ORDER BY, COMPUTE, or COMPUTE BY
clauses or the INTO keyword.
You cannot define full-text index definitions on views.
You cannot create temporary views, and you cannot create views on temporary tables.

Views or tables participating in a view created with the SCHEMABINDING clause cannot
be dropped, unless the view is dropped or changed so that it no longer has schema binding.
In addition, ALTER TABLE statements on tables that participate in views having schema
binding will fail if these statements affect the view definition.
You cannot issue full-text queries against a view, although a view definition can include a
full-text query if the query references a table that has been configured for full-text indexing.
You must specify the name of every column in the view if:
Any of the columns in the view is derived from an arithmetic expression, a built-in
function, or a constant.
Two or more of the columns in the view would otherwise have the same name (usually
because the view definition includes a join and the columns from two or more different
tables have the same name).
You want to give any column in the view a name different from the column from which it
is derived. (You can also rename columns in the view.) A view column inherits the data
type of the column from which it is derived, whether or not you rename it.

Figure 5.2

Notes This rule does not apply when a view is based on a query containing an outer join
because columns may change from not allowing null values to allowing them.

LOVELY PROFESSIONAL UNIVERSITY 67