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 stretch database in sql server?
Explain data warehousing in sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What are the indexes in sql server?
What is the report builder?
How do you rebuild an identity column?
What is a database table?
What is bulkcopy in sql?
How to get @@error and @@rowcount at the same time?
What do you understand by the denormalisation?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Why use identity in sql server?
What is a hint?
How to get a list of columns in a view using the "sp_help" stored procedure?
What are the different kinds of ssrs reports?
