SQL Server Architecture Question: Download MS SQL Server Architecture PDF
Can you explain what are the restrictions applicable while creating views?
Answer:
Restrictions 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.
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.
| Previous Question | Next Question |
| Explain what are the restrictions that views have to follow? | Explain the truncate command? |