What is View?

Ads
 

What is View?

What is View?

View Answers

November 18, 2010 at 3:43 PM

Hi,

A SQL View is a virtual table, which is based on SQL SELECT query. Essentially a view is very close to a real database table (it has columns and rows just like a regular table), except for the fact that the real tables store data, while the views don?t. The view?s data is generated dynamically when the view is referenced. A view references one or more existing database tables or other views. In effect every view is a filter of the table data referenced in it and this filter can restrict both the columns and the rows of the referenced tables.

The syntax for creating a VIEW is:

CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;

Ads









Related Tutorials/Questions & Answers:
using session variable determine the no of pages viewd by the user
Creating Views
Advertisements
Version of com.alexvasilkov>gesture-views dependency
Version of com.androidhuman>fixedratio-views dependency
Redirecting and forwarding to views
Version of com.belladati>belladati-android-views dependency
Version of com.gethalfpint>dropwizard-views-jade dependency
Version of com.porch>dropwizard-views-handlebars dependency
Maven Dependency gesture-views >> 1.0.1
Maven Dependency gesture-views >> 1.0.2
Maven Dependency gesture-views >> 2.0.0
Maven Dependency gesture-views >> 2.0.0-beta-1
Maven Dependency gesture-views >> 2.0.0-beta-2
Maven Dependency gesture-views >> 2.0.1
Maven Dependency gesture-views >> 2.0.2
Maven Dependency gesture-views >> 2.0.3
Maven Dependency gesture-views >> 2.1.0
Maven Dependency gesture-views >> 2.1.1
Maven Dependency gesture-views >> 2.2.0
Maven Dependency gesture-views >> 2.3.0
Maven Dependency fixedratio-views >> 0.1.0
Retrieve values from database using views
Why are MySQL Routines and Views not used with PHP?
Maven Dependency belladati-android-views >> 1.4
Maven Dependency belladati-android-views >> 1.6
Maven Dependency belladati-android-views >> 1.6.2
Maven Dependency belladati-android-views >> 1.6.3
Maven Dependency belladati-android-views >> 1.6.4
Maven Dependency belladati-android-views >> 1.6.5
Maven Dependency belladati-android-views >> 1.6.6
Maven Dependency dropwizard-views-handlebars >> 0.7.1

Ads