Answer Posted / guest
When you use this option to create a view with a where
condition, the system wont allow to perform any action which
will invalidate the definition of the view.
ex:
create view test
as
select firstname,lastname from Employees where sal<10000
with Check option
If this returns 10 rows when you are updating the view if
any action is being done which updates the sal so that the
view returns lesser number of records is not allowed.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can you edit the .rdl code associated with a linked report?
What is a field name?
Do you know what are the properties of the relational tables?
Explain syntax for dropping triggers?
what is a correlated sub-query? : Sql server database administration
What is #temp and @table variable in SQL server?
How to integrate the ssrs reports in application?
What is b tree index?
Is mysql better than sql server?
Which joins are sql server default?
Explain about nested stored procedure?
what is unique and xaml nonclustered index
What do you understand by SQL*Net?
What is log ldf?
What is explicit cursors?
