TDV Adapter for Google Spanner

Build 21.0.8137

CREATE TABLE Statements

To create new Google Spanner entities, use CREATE TABLE statements.

CREATE TABLE Syntax

The CREATE TABLE statement specifies the table name and a comma-separated list of column names and the primary keys of the table, as shown in the following example:

CREATE TABLE <table_name> [ IF [ NOT EXISTS ] ]
( 
  { 
     <column_name> <data_type> 
     [ NOT NULL ] 
     [ DEFAULT <literal> ] 
     [ PRIMARY KEY ] 
     [ UNIQUE ] 
  } |  PRIMARY KEY ( <column_name> [ , ... ] ) 
  [ , ... ]
)

The following example statement creates a MyCustomers table on the Google Spanner server with name, age, and address columns:

CREATE TABLE IF NOT EXISTS "MyCustomers" (name VARCHAR(20), age INT, address VARCHAR(20))

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137