Updating views in sql

The purpose of the WITH CHECK OPTION is to ensure that all UPDATE and INSERTs satisfy the condition(s) in the view definition.

If they do not satisfy the condition(s), the UPDATE or INSERT returns an error.

To create a view, a user must have the appropriate system privilege according to the specific implementation.

Staff (which is all I can currently achieve) In this context does the definition of 'base table' not extend to any subsequently joined tables?A view can contain all rows of a table or select rows from a table.A view can be created from one or many tables which depends on the written SQL query to create a view.-If the view has not been defined using groups and aggregate functions.-If the view does not have any distinct clause in its definition.Although such a view is not insertable, it can be updatable if you update only columns that are not expressions.

You must have an account to comment. Please register or login here!