1.

Explain What Are The Restrictions That Views Have To Follow?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions