CREATE TABLE - Amazon Quantum Ledger Database (Amazon QLDB)

CREATE TABLE

Use the CREATE TABLE statement to create a new table in your Amazon QLDB ledger.

Tables have simple names with no namespaces. QLDB supports open content and does not enforce schema, so you don't define attributes or data types when creating tables.

Syntax

CREATE TABLE table

Parameters

table

The name of the table to create. The following are the naming constraints:

  • Must only contain 1–128 alphanumeric characters or underscores.

  • The first character must be a letter or an underscore.

  • The remaining characters can be any combination of alphanumeric characters and underscores.

  • The table names are case sensitive.

  • The name must not be a QLDB PartiQL reserved word.

Return value

tableId – The ID of the table that you created.

Examples

CREATE TABLE VehicleRegistration

Running programmatically using the driver

To learn how to programmatically run this statement using the QLDB driver, see the following tutorials in Getting started with the driver: