|
||||||||||||||
|
||||||||||||||
|| 
|| 
|| | SQL Basics |
 Introduction |
|
Create Tables
|
|
Data Type
|
|
Delete/Modify Table
|
|
Add Rows
|
|
Create Sequence
|
|
Quiries
|
|
Single-Row Function
|
|
Group Functions
|
|
Joints
|
|
Create Views
|
| Books @ |
|
CA Amazon |
|
UK Amazon |
| US Amazon |
| :: Home |
| PC Topics |
| :: Build A PC |
| :: Windows XP |
| :: PC Help |
| Tutorials |
| :: HTML |
| :: JavaScript |
| :: ASP |
| :: PHP |
| :: VBScript |
| :: SQL |
| Miscellaneous |
| :: Code/Scripts |
| :: Forum |
| :: Links |
| :: Contact us |
| :: Tell A Friend |
| :: In Somali |
| :: |
| Web Articles |
|
Top Web Hosting Reviews |
|
Processing Online Card Payment Guide |
|
Domain name registration & buying guide |
|
Getting a website online guide |
|
Search Engine submission & optimization tips |
|
| SQL View is a virtual or temporary table. Sql view is similar to
the query in access so that you retrieve data from a table and store it in a view.
Views are often created because of security reasons or to retrieve and store data
from different tables. You can create a view same way as a table. Select statement
is used to retreive data from a table. Here is an example of creating a view: | |
| CREATE VIEW product_view AS
SELECT name, description FROM product; | The name of the view we just created is product_view, which selects two columns, name and desc from product table. The values from these two columns will be stored in this view. |
 Home
| |
|
| PC Articles |
|
Computer Safety prevent viruses & Spyware |