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
How do I partition a table in sql server?
How to Sync Two SQL Azure Databases?
How to create function without parameter in sql server?
What do you understand by intent locks?
how can you check the level of fragmentation on a table? : Sql server administration
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What does the update command do?
What is autocommit mode in sql server?
How would you add a section to a table?
What is the difference between a "where" clause and a "having" clause?
What are ddl (data definition language) statements for tables in ms sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is fill factor and pad index?
What are the features of Embedded SQL