Neoview SQL Reference Manual (R2.4)

CREATE TABLE Statement
• “Syntax Description of CREATE TABLE”
• “Considerations for CREATE TABLE”
• “Examples of CREATE TABLE”
The CREATE TABLE statement creates a Neoview SQL table. The CREATE VOLATILE TABLE
statement creates a Neoview SQL table in a SQL session. Volatile tables are dropped automatically
when the session ends. The CREATE TABLE AS statement creates a table based on the data
attributes of a SELECT query and populates the table using the data returned by the SELECT
query. A CREATE SET TABLE is like any other normal table with the additional property of
discarding duplicate rows. See “Database Object Names” (page 228).
70 SQL Statements