adspace
Explain what are the restrictions that views have to follow? : sql server architect
Answer Posted / Ram Narayan Prajapati
"Views in SQL Server have several restrictions, including: 1) They cannot contain multiple SELECT statements or UNION operators. 2) They cannot modify data (INSERT, UPDATE, DELETE), although they can be used in these statements as a source for data manipulation. 3) They cannot be indexed directly, but indexes can be created on underlying tables that the view references. 4) They cannot contain subqueries within SELECT statements, though you can use them in FROM clause of subqueries."n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers