Can you explain what are the restrictions applicable while creating views?
Submitted by: AdministratorRestrictions applicable while creating views:
A view cannot be indexed.
A view cannot be Altered or renamed. Its columns cannot be renamed.
To alter a view, it must be dropped and re-created.
ANSI_NULLS and QUOTED_IDENTIFIER options should be turned on to create a view.
All tables referenced in a view must be part of the same database.
Any user defined functions referenced in a view must be created with SCHEMABINDING option.
Cannot use ROWSET, UNION, TOP, ORDER BY, DISTINCT, COUNT(*), COMPUTE, COMPUTE BY in views.
Submitted by: Administrator
A view cannot be indexed.
A view cannot be Altered or renamed. Its columns cannot be renamed.
To alter a view, it must be dropped and re-created.
ANSI_NULLS and QUOTED_IDENTIFIER options should be turned on to create a view.
All tables referenced in a view must be part of the same database.
Any user defined functions referenced in a view must be created with SCHEMABINDING option.
Cannot use ROWSET, UNION, TOP, ORDER BY, DISTINCT, COUNT(*), COMPUTE, COMPUTE BY in views.
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. |
