Answers

Question and Answer:

  Home  SQL Server Views

⟩ Do you know what are the restrictions that views have to follow?

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.

 144 views

More Questions for you: