Hi all...


A SQL view is a virtual table and the SQL CRERATE VIEW statement is the SQL command that adds a new view to a SQL database.

A view can be accessed using the SQL SELECT statement like a table. A view is built by selecting data from one or more tables.

Some views can also support the SQL INSERT, SQL UPDATE and SQL DELETE statements. In that case, the view must refer to a single table and include all NOT NULL columns of that table.


Thanks...