UVM Logo

The
University
of
Vermont

 



Views


A VIEW behaves just like a table. SELECT column, column FROM view-name WHERE conditions 

A view is created through a SELECT statement.

CREATE VIEW perm_addresses as (SELECT * FROM SATURN.SPRADDR WHERE SPRADDR_ATYP_CODE = 'AP');

A VIEW is a "logical" table.

 

Copyright 1995 University of Vermont and others. All rights reserved.

Brought to you through the courtesy of Computing and Information Technology, University of Vermont. Copyright © 1996 The University of Vermont and others. All rights reserved.

The University supports both institutional and personal web pages. The views expressed on personal web pages are strictly those of the author, and are not reviewed or approved by the University of Vermont

Read the Webmaster's Policies.

Send questions and comments to webmaster@uvm.edu

Last page update: March 21, 1997