What do you understand by a view? What does WITH CHECK OPTION clause for a view do?

- A view is a virtual table which comprises fields from one or more real tables.

- It is generally used to join multiple tables and get the data.

- WITH CHECK OPTION for a view prevents any modification to the data that doesn't confirm to WHERE clause of the view definition.

- This allows data belonging to the view to be updated through view.

 

Posted Date: 9/7/2013 3:05:31 AM | Location : United States

Ask an Expert

Related Discussions:- What do you understand by a view, Assignment Help, Ask Question on What do you understand by a view, Get Answer, Expert's Help, What do you understand by a view Discussions

Write discussion on What do you understand by a view
Your posts are moderated

Write your message here..

Related Questions

Student database, tell me the functionality,advantages and disadvantages of... tell me the functionality,advantages and disadvantages of student database

Create records in a table - data structures, In this exercise you will crea... In this exercise you will create ten records, each containing the following fields: student name, class:  Freshman, Sophomore, Junior or Senior, Major:  Liberal Arts or General Sci

Linear commit protocol, With the linear commit protocol, sites are connecte... With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol

Functional Dependencies, What exactly is the concept of Functional Dependen... What exactly is the concept of Functional Dependencies? And how do we associate this concept with the logic of Super-keys, Candidate Keys, etc? Given Relation R(A,B,C,D,E) with de

Natural join-table handling, Natural Join : It is the similar like Equi joi... Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation

Discuss the count function, Discuss the count function? The COUNT funct... Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)

Explain function group, What is a function group? A function group is ... What is a function group? A function group is a collection of logically related modules that share global data with every other.  All the modules in the group are contained in

Difference between clustered and a non-clustered index, What are the differ... What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

What are object interaction diagrams, What are object interaction diagrams?... What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

What creates while a primary key is combined with a foreign, What it create... What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w