Limits applicable for creating views

Question

What are the limits applicable when creating views?

Answer 1

The limits applicable while creating views are as follows:

• Views can be created by referencing tables and views simply into the current database.

• A view name should not be similar as any table owned by such user.

• You can build views upon other views and upon procedures which reference views.

• Rules or DEFAULT descriptions can't be associated along with views.

• Only INSTEAD OF triggering can be related with views.

• The query which defines the view cannot contain the COMPUTE or COMPUTE BY or say ORDER BY clauses or the INTO keyword.

• You can’t describe full-text index definitions for views, can’t create temporary views and can’t create views upon temporary tables.