What are the restrictions that views have to follow?
- 1 Answers
- 1055 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vivek Anand
{"View Restrictions": "Views can contain joins, aggregations, and calculations but cannot contain DDL statements (CREATE, ALTER, or DROP), triggers, or transaction control statements. Views also cannot be indexed directly; instead, indexes are created on the underlying table that supports the view.","Nested View Restrictions": "SQL Server does not support nested views, except for scalar-valued functions and system views that rely on the SQL SERVER internal implementation of nested views."}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is spatial nonclustered index
What is an indexed view?
Why and when do stored procedure recompile?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is in place upgrade in sql server?
What is the difference between for xml raw and for xml auto?
How to rebuild the master database?
What is normalization and what are the advantages of it?
What are different types of constraints?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the different SQL Server Versions you have worked on?
How can we solve concurrency problems?
How raid can influence database performance?
Can you index views?
What are wait types?
