Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Displaying Data Through Views

Creating a view doesn't produce a display. When SQL receives a CREATE VIEW command, it does not actually execute the SELECT statement that follows the keyword AS. Instead, it stores the SELECT statement in the system catalogs.

In order to see data through the view, query the view, just as you would a table.

SQL

select *
from oaklanders FirstName LastName Book ========= ========== =============================================== Marjorie Green The Busy Executive's Database Guide Stearns MacFeather Cooking with Computers: Surreptitious Balance Sheets Marjorie Green You Can Combat Computer Stress! Dick Straight Straight Talk About Computers Livia Karsen Computer Phobic and Non-Phobic Individuals: Behavior Variations ...