7.1

SQL View Explained

SQL Views

  • A SQL view is a SELECT statement that is stored as a database object.
  • A SQL view acts as a virtual table but contains no data.
  • You can use a view anywhere you would use a table including in a SELECT, INSERT, UPDATE, or DELETE statement.
CC BY-NC-ND International 4.0

CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.