.create table command

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

Creates a new empty table.

The command must run in the context of a specific database.

Permissions

You must have at least Database User permissions to run this command.

Syntax

.create table tableName (columnName:columnType [, ...]) [with (propertyName = propertyValue [, ...])]

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
tableName	string	✔️	The name of the table to create.
columnName, columnType	string	✔️	The name of a column mapped to the type of data in that column. The list of these mappings defines the output column schema.
propertyName, propertyValue	string		A comma-separated list of key-value property pairs. See supported properties.

Supported properties

Name	Type	Description
docstring	string	Free text describing the entity to be added. This string is presented in various UX settings next to the entity names.
folder	string	The name of the folder to add to the table.

Note

If a table with the same (case-sensitive) name already exists in the context of the database, the command returns success without changing the existing table, even in the following scenarios:

• The specified schema doesn't match the schema of the existing table
• The folder or docstring parameters are specified with values different from the ones set in the table

Example

.create table MyLogs ( Level:string, Timestamp:datetime, UserId:string, TraceId:string, Message:string, ProcessId:int32 ) 

Output

Returns the table's schema in JSON format, same as:

.show table MyLogs schema as json

Note

For creating multiple tables, use the .create tables command for better performance and lower data load.