SQL Server Architecture Question:
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.
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.
| Previous Question | Next Question |
| Do you know what are the restrictions applicable while creating views? | Can you explain what are the restrictions applicable while creating views? |