|SQL - Structured Query Language|
WITH CHECK OPTION - VIEW
WITH CHECK OPTION is used to forces all data modification statements executed against the view to follow the criteria set within select statement. When a row is modified through a view, the WITH CHECK OPTION makes sure the data remains visible through the view after the modification is committed.
The following query is used to create view that helps to list out and maintain System Department Employee Detail by using SQL join concept.
Query Output Screen
Note: Any updates performed directly to a view's underlying tables are not verified against the view, even if CHECK OPTION is specified.
* * * * *