JDBC Driver for Databricks

Build 22.0.8462

CREATE TABLE Statements

To create new Databricks 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 [ IF NOT EXISTS ] <table_name>
(
  {
     <column_name> <data_type>
     [ NOT NULL ]
  }
  [ , ... ]
)

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

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462