CREATE VIEW
CREATE VIEW <view_name> [(column1, column2...)] AS
SELECT <table_name column_names>
FROM <table_name>
using the CREATE VIEW statement. After a view is created, it can be queried and data within the view can be modified.
Saturday, 24 March 2012 by Unknown | 0 Comments