When querying through a view, the Database Engine checks to make sure that all the database objects referenced anywhere in the statement exist and that they are valid in the context of the statement, and that data modification statements do not violate any data integrity rules.
SalesTerritoryKey ; See Also. Note The preferred method for partitioning data local to one server is through partitioned tables. It cannot be a computed, identity, default, or timestamp column. For more information, see Modify Data Through a View.
Remarks A view can be created only in the current database.
Person p ON p. Any columns in remote tables of type smallmoney that are referenced in a partitioned view are mapped as money.
A view can have a maximum of 1, columns. BusinessEntityID, e.