2nd April 2013, 04:10 PM
Views database management system pdf free
SQL - CREATE VIEW
CREATE VIEW ViewName [ (newColumnName [,...]) ]
[WITH [CASCADED | LOCAL] CHECK OPTION]
- Can assign a name to each column in view.
- If list of column names is specified, it must have same number of items as number of columns produced by subselect.
- If omitted, each column takes name of corresponding column in subselect.
- List must be specified if there is any ambiguity in a column name.
Tags for this Thread