![]() |
SQL-J Language Reference
|
Reference Manual |
CREATE VIEW statementViews are virtual tables formed by a query. A view is a dictionary object that you can use until you drop it. Views cannot be created in the SYS schema. Syntax
CREATE VIEW ViewName A view definition can contain an optional view column list to explicitly name the columns in the view. If there is no column list, the view inherits the column names from the underlying query, including any internally generated names for unnamed columns. All columns in a view must be uniquely named. Example
CREATE VIEW v1 (col_sum, col_diff)
CREATE VIEW BigStates (StateName)
CREATE VIEW Segments_SeatBookings Dependency SystemView definitions are dependent on the tables, views, and aliases referenced within the view definition. DML (data manipulation language) statements that contain view references depend on those views, as well as the objects in the view definitions that the views are dependent on. In Version 3.0, a view is not dependent on indexes. Statements that reference the view depend on indexes the view uses; which index a view uses may change from statement to statement based on how the query is optimized. For example, given: CREATE TABLE T1 (C1 DOUBLE PRECISION)
CREATE METHOD ALIAS sin |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |