CSS font stacks & developer FAQs with Web standards
One of hundreds of answers available with our premium content service.
A: A database view is a temporary, selective representation of database fields from one or more tables. The view data is held in a structure that behaves like, and can be treated as, a standard database table. The field values held in a view are dynamically updated as the tables they refer to are changed, so the view is always current.
Database views are created by assigning the results of a standard SQL query to a named view, as in the simple example below. Views are typically used to make a simplified extract from a complex data set, so the queries used to create them tend to be relatively complex. View selections may also cast data from one type to another for convenience.
… full answer hidden
Premium members click below for full answer
What is a database view?