Explain what are the restrictions that views have to follow?
Submitted by: AdministratorSince 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SQL Server Architecture Job Interview Questions And Answers
Top SQL Server Architecture Questions
☺ | What do you know about system database? |
☺ | Explain the Microsoft SQL Server delete command? |
☺ | What is Model Database? |
☺ | Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? |
☺ | What is MSDB Database? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |