CREATE a VIEW - Revision history

Marek at 10:52, 18 July 2012

2012-07-18T10:52:26Z

Marek at 14:00, 17 July 2012

2012-07-17T14:00:23Z

Marek: Created page with "CREATE a VIEW.

schema:scott

A view is a named SELECT statement. In this example we show only European countries, we also show t..."

2012-07-12T15:14:42Z

Created page with "CREATE a VIEW. <div class='ht'> <div class=params>schema:scott</div> <div> A view is a named SELECT statement. In this example we show only European countries, we also show t..."

New page

CREATE a VIEW.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
A view is a named SELECT statement.

In this example we show only European countries, we also
show the population in millions.

Note how the columns of the table may be named.
</div>

<source lang=sql class='tidy'>DROP VIEW v_europe</source>
<source lang=sql class='tidy e-access'>DROP TABLE v_europe</source>
<source lang=sql class='setup'>DROP TABLE world;
CREATE TABLE world(
name VARCHAR(50) NOT NULL
,region VARCHAR(60)
,population DECIMAL(11)
,PRIMARY KEY (name)
);
INSERT INTO world VALUES ('China','Asia',1261);
INSERT INTO world VALUES ('France','Europe',59);
INSERT INTO world VALUES ('India','Asia',1014);
INSERT INTO world VALUES ('Italy','Europe',57);
INSERT INTO world VALUES ('Japan','Asia',126);
INSERT INTO world VALUES ('Russia','Asia',146);
INSERT INTO world VALUES ('Spain','Europe',39);
</source>

<source lang='sql' class='def'>CREATE VIEW v_europe AS
SELECT name,
population AS pop
FROM world
WHERE region='Europe';

SELECT * FROM v_europe
</source>

<div class="ecomm e-mysql" style="display: none">A view is called a ''query'' in Microsoft Access.
Use DROP TABLE to remove a view.</div>
</div>
{{CREATE and DROP ref}}

@@ Line 38: / Line 38: @@
 </source>
-<div class="ecomm e-mysql" style="display: none">A view is called a ''query'' in Microsoft Access.
+<div class="ecomm e-access" style="display: none">A view is called a ''query'' in Microsoft Access.
     Use DROP TABLE to remove a view.</div>
 </div>
 {{CREATE and DROP ref}}

@@ Line 12: / Line 12: @@
 <source lang=sql class='tidy'>DROP VIEW v_europe</source>
-<source lang=sql class='tidy e-access'>DROP TABLE v_europe</source>
+<!--<source lang=sql class='tidy e-access'>DROP TABLE v_europe</source>-->
 <source lang=sql class='setup'>DROP TABLE world;
 CREATE TABLE world(

CREATE a VIEW - Revision history

Marek at 10:52, 18 July 2012

Marek at 14:00, 17 July 2012

Marek: Created page with "CREATE a VIEW. schema:scott A view is a named SELECT statement. In this example we show only European countries, we also show t..."

Marek: Created page with "CREATE a VIEW.

schema:scott

A view is a named SELECT statement. In this example we show only European countries, we also show t..."