.create-merge table

Creates a new table or extends an existing table.

The command must run in context of a specific database.

Requires Database user permission.

Syntax

.create-merge table TableName ([columnName:columnType], ...) [with ([docstring = Documentation] [, folder = FolderName] )]

If the table doesn't exist, functions exactly as ".create table" command.

If table T exists, and you send a ".create-merge table T ()" command, then:

  • Any column in that didn't previously exist in T will be added to the end of T's schema.
  • Any column in T that is not in won't be removed from T.
  • Any column in that exists in T, but with a different data type will cause the command to fail.

See also