CREATE TABLE [AS] ( Object File System Form) | VantageCloud Lake - CREATE TABLE and CREATE TABLE AS (Object File System Table Form)

CREATE TABLE [AS] ( Object File System Form) | VantageCloud Lake - CREATE TABLE and CREATE TABLE AS (Object File System Table Form) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

The Object File System table form of CREATE TABLE or CREATE TABLE AS creates a table in Native Object Storage (an Object File System table). CREATE TABLE AS copies the new table column definitions, and optionally its data and statistics, from an existing table. The existing table need not be an Object File System table.

The PRIMARY INDEX clause can be used on an OFS table. An OFS PI table optionally can have an ORDER BY clause. The syntax and other table level options/clauses are the same as for an OFS NoPI table.

CREATE TABLE Syntax (Object File System Table Form)
CREATE TABLE and CREATE TABLE AS Syntax Elements (Object File System Table Form)
CREATE TABLE and CREATE TABLE AS Usage Notes (Object File System Table Form)
Creating an Object File System Table
Examples: OFS Tables with PRIMARY INDEX