Restriction on Views in Microsoft SQL Server

Restrictions are applied when we create views in Microsoft SQL Server. These restrictions are listed below :

1. Views created, only referencing tables and views in current database. 
2. View name must not match with the name of table owned by that user.
3. Views can be built based on other views and on procedures that reference views.
4. We cannot associate Rules or DEFAULT definitions with views.
5. We can only associate INSTEAD OF triggers with views.
6. ORDER BY, COMPUTE, COMPUTE BY clauses and INTO keyword cannot be included in query that defines view.
7. Full-text index definitions cannot be used for views.
8. Temporary views cannot be created
9. Views cannot be created on temporary tables.

See Also