CREATE TABLE and CREATE TABLE AS Examples

Examples: MAP Option
Example: Specifying MERGEBLOCKRATIO Settings
Example: Specifying DATABLOCKSIZE, CHECKSUM, and FREESPACE
Example: CHARACTER Partitioning Using a CASE_N Function
Example: CHARACTER Partitioning Defined Using a RANGE_N Function
Example: Character Partitioning Defined Using RANGE_N Functions
Example: Character Partitioning, Session Mode, and Case Specificity
Example: Character Partitioning and System-Derived PARTITION[#Ln] Columns
Example: RANGE_N Partitioning Expression Using the END Bound Function
Example: CASE_N Partitioning Expression Using the END Bound Function
Example: 15 Levels of Multilevel Partitioning
Example: Volatile Table with Single-Level Partitioning
Example: Global Temporary Table with Single-Level Partitioning
Example: Specifying a Column-Level Primary Key
Example: Default Primary Index When Neither Primary Index nor Primary Key Is Specified
Example: Local Journaling
Example: CREATE TABLE AS … WITH NO DATA with Named Expressions
Example: CREATE TABLE AS ... WITH NO DATA with Nonunique Secondary Index
Example: CREATE TABLE AS … WITH DATA with Nonunique Secondary Index
Example: Statistics Not Copied
Example: Statistics Are Not Copied for Conditions in the Subquery
Example: Statistics Are Not Copied When Set Or Aggregation Operators Are Specified in the Query
Example: Statistics Are Not Copied If an OLAP Operation Is Specified in the Subquery
Example: Statistics Are Not Copied If a Join Operation Is Specified in the Subquery
Example: Statistics Are Not Copied If Functions or Expressions Are Specified in the Subquery
Example: CREATE TABLE AS Requests that Create Table with Primary Index
Example: CREATE Request with Presence or Absence of PRIMARY KEY or UNIQUE Constraint and Setting of PrimaryIndexDefault
Example: NoPI Table CREATE Request that Converts PRIMARY KEY or UNIQUE Constraints to USIs
Example: CREATE Request that Produces a NoPI Table
Example: CREATE TABLE … AS Requests that Create NoPI Table
Example: Current and Historical Partitioning Using CURRENT_DATE in a CASE_N Expression
Example: CURRENT_DATE Built-In Function in a CASE_N Expression
Example: Quarterly Partitioning Using CURRENT_DATE in a RANGE_N Expression
Example: Current and Historical Partitioning Using CURRENT_DATE in a CASE_N Expression
Example: Partitioning Expression with TIMESTAMP Data Type
Example: Partitioning Expression that Specifies AT LOCAL Date
Example: Grouping Columns in the Column List of a Column-Partitioned Table Rather than in the Partitioning Expression
Example: Column-Partitioned Table with Default Autocompression
Example: Columns Defined Using Different Types of NUMBER Types
Example: Create Tables with ST_GEOMETRY Data Type Columns
Example: Create Tables with XML Data Type Columns
Example: Create Tables with JSON Data Type Columns
Example: Creating a Table with Row-Level Security Constraints
Example: Specifying Block-Level Compression Set to ALWAYS
Example: Specifying Block-Level Compression Set to AUTOTEMP
Examples: Creating a Table with a JSON Auto Column
Examples: Compression Attribute
Examples: Constraint Attribute
Example: Creating a Table with a Derived Period Column
Example: NORMALIZE
FOREIGN KEY Constraint Examples
Examples: PRIMARY INDEX
Examples: PRIMARY AMP
Example: Multilevel-Partitioned NUPI with a USI Defined on the Primary Index
Examples: PARTITION BY
Examples: AS Clause
Examples: AUTODBA Option

CREATE TABLE and CREATE TABLE AS Examples - Teradata Vantage

Teradata® VantageCloud Lake