In a view, WITH CHECK OPTION

Options
- Specifies that only the rows that would be retrieved by the subquery can be inserted
- Specifies that only the rows that would be retrieved by the subquery can be updated
- Specifies that only the rows that would be retrieved by the subquery can be deleted
- Specifies that only the rows that would be retrieved by the subquery can be inserted, updated, or deleted

CORRECT ANSWER : Specifies that only the rows that would be retrieved by the subquery can be inserted, updated, or deleted

Discussion Board
View - WITH CHECK Option

The WITH CHECK OPTION clause is an optional part of the CREATE VIEW statement. The WITH CHECK OPTION clause prevents you from updating or inserting rows that are not visible through the view. In other words, whenever you update or insert a row of the base table through a view, MySQL ensures that the insert or update operation conforms to the definition of the view.

Syntax:
CREATE OR REPLACE VIEW view_name
AS
select_statement
WITH CHECK OPTION;

Note that you put the semicolon (;) at the end of the WITH CHECK OPTION clause, not at the end of the SELECT statement defined the view.

Prajakta Pandit 02-14-2017 06:34 AM

sql

good!! learnt alot thank you

Priya 08-18-2016 01:11 AM

kk@gmail.com

ok

kk 01-9-2015 06:37 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲