SQL Server Architecture Question:
Download Questions PDF

Do you know what are the restrictions applicable while creating views?

Answer:

Views can be created referencing tables and views only in the current database.
A view name must not be the same as any table owned by that user.
You can build views on other views and on procedures that reference views.
Rules or DEFAULT definitions can't be associated with views.
Only INSTEAD OF triggers can be associated with views.
The query that defines the view cannot include the ORDER BY, COMPUTE, or COMPUTE BY clauses or the INTO keyword.
You cannot define full-text index definitions for views.
You cannot create temporary views
You cannot create views on temporary tables.

Download MS SQL Server Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between CUBE operator and ROLLUP operator?Explain what are the restrictions that views have to follow?