Since a view is a virtual table – columns of the view cannot be renamed. To change anything in the view, the view must be dropped and create again.

The select statement on the view cannot contain ORDER BY or INTO TEMP

When a table or view is dropped, any views in the same database are also dropped.

It is not possible to create an index on a view

It is not possible to use DELETE to update a view that is defined as a join.