Updating Views

A VIEW is a command that can use a combination of tables and joins to show the user or program a set of predefined data, as required. Effectively, it gives you a view of the data. You cannot DELETE, UPDATE, or INSERT from a view.

As a view is defined with a specific name, which is stored in the database, it can be effectively referenced as a table to another SQL statement, as part of a statement to be manipulated.

If a keyword such as Temporary or Temp exists within the create and view words, then that view is only seen by that database connection and is removed upon the connection closing, hence the temp/temporary name.

If a database name is referenced when the view is created, it will reside within that specific database.