الملاحظات تحرير

.create-merge table

  • مقالة
  • قراءة خلال 2 دقائق

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 (<columns specification>) command, then:

  • Any column in <columns specification> 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 <columns specification> won't be removed from T.
  • Any column in <columns specification> that exists in T, but with a different data type will cause the command to fail.

See also