What Are The Restrictions Applicable While Creating Views?

1.	What Are The Restrictions Applicable While Creating Views?
Answer» Views can be CREATED referencing tables and views only in the current database. A view name must not be the same as any table owned by that user. You can build views on other views and on procedures that REFERENCE views. Rules or DEFAULT definitions can't be associated with views. Only INSTEAD OF triggers can be associated with views. The query that defines the view cannot include the ORDER BY, COMPUTE, or COMPUTE BY clauses or the INTO KEYWORD. You cannot DEFINE full-text index definitions for views. You cannot create temporary views You cannot create views on temporary tables.

Answer»

Views can be CREATED referencing tables and views only in the current database.
A view name must not be the same as any table owned by that user.
You can build views on other views and on procedures that REFERENCE views.
Rules or DEFAULT definitions can't be associated with views.
Only INSTEAD OF triggers can be associated with views.
The query that defines the view cannot include the ORDER BY, COMPUTE, or COMPUTE BY clauses or the INTO KEYWORD.
You cannot DEFINE full-text index definitions for views.
You cannot create temporary views
You cannot create views on temporary tables.

Discussion