Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is trigger explain with program?
Does index slows down insert statements?
How do I view a stored procedure in sql server query?
How to loop through returning rows?
How do you rebuild an identity column?
how you can configure a running aggregate in SSRS?
Can you roll back the ddl statement in a trigger?
What happens if we shrink log file in sql server?
What is mean by dml?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is precedence constraint?
What is the difference between commit and rollback?
How can you manage sql azure security?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How do I install only the client tools of sql server 2000?
