The CREATE TABLE AS form copies column definitions to a new table. Optionally, data and statistics are copied to the new table.
- CREATE TABLE AS Required Privileges
- Copying Table Definitions
- Target Table Kind Defaults
- Exclusions from CREATE TABLE … AS Syntax
- CREATE TABLE (AS Clause) General Usage Rules
- Usage Rules for Normalized Tables
- Attributes Not Copied to The Target Table
- Using Subqueries to Customize an AS Clause
- Exclusive AS … WITH DATA Clause Rules
- Comparing PARTITION Statistics Copied with COLLECT STATISTICS … FROM source_table to PARTITION Statistics Copied with CREATE TABLE AS … WITH DATA AND STATISTICS
- General Rules for CREATE TABLE AS … WITH DATA AND STATISTICS
- Rules for CREATE TABLE AS … WITH DATA AND STATISTICS without Subquery to Define Source Table Column and Index Set
- Rules for AS … WITH DATA AND STATISTICS that Uses a Subquery to Define the Source Table Column and Index Set
- General Rules for CREATE TABLE AS … WITH NO DATA
- Rules for CREATE TABLE AS … WITH NO DATA that Does Not Use a Subquery to Define the Source
- Rules for AS … WITH NO DATA that Defines Source with Subquery
- Misleading Similarities of WITH DATA and WITH NO DATA Clauses
- CREATE TABLE AS Related Information