.create tables.create tables

• 08/18/2020
• • o
  • v

创建新的空表作为批量操作。Creates new empty tables as a bulk operation.

该命令必须在特定数据库的上下文中运行。The command must run in context of a specific database.

需要数据库用户权限。Requires Database user permission.

语法Syntax

.create tables TableName1 ([columnName:columnType], ...) [, TableName2 ([columnName:columnType], ...) ... ] [with ( folder = FolderName] )].create tables TableName1 ([columnName:columnType], ...) [, TableName2 ([columnName:columnType], ...) ... ] [with ( folder = FolderName] )]

如果已经存在任何表，命令将返回成功。If any table already exists, the command will return success.

示例Example

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