Neoview SQL Reference Manual (R2.3)

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
CREATE TABLE Statement 69