Answers

Question and Answer:

  Home  Basic SQL Server

⟩ Tell me what do you understand by a view? What does the WITH CHECK OPTION clause for a view do?

- A view is a virtual table that consists of fields from one or more real tables.

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

- The WITH CHECK OPTION for a view prevents any modification to the data that does not confirm to the WHERE clause of the view definition.

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

 162 views

More Questions for you: