SQL Database Concepts Question: Download Basic SQL Server PDF
Tell me what do you understand by a view? What does the WITH CHECK OPTION clause for a view do?
Answer:
- 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.
- 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.
| Previous Question | Next Question |
| Tell me When is the UPDATE_STATISTICS command used? | Explain what is the function of SQL Server Agent Windows service? |