Create View

Syntax...


Create a view... simple... except when ARTHRITIS PAIN FLARES UP.

The Syntax:

 CREATE
[OR REPLACE]
[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

CREATED 2012-12-25 05:48:53.0

00-18-F6

UPDATED 2012-12-25 05:54:00.0

Example...


SELECT * FROM EmpList;

A real life example... Create a view to see list of employees...

 Create View EmpList
SELECT LastName, FirstName, MiddleName FROM Employee Order by LastName, FirstName, MiddleName;

Execute in like this:

Views do save a lot of time.

CREATED 2012-12-25 05:53:47.0

00-18-F7

UPDATED 2012-12-25 05:53:57.0

Knowledge

DOCS
L
I
N
K
S

DBID: db.wam

Page Server: Ruger

©2012 Leistware Data Systems

      Hello anonymous