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.