.create tables.create tables
创建新的空表作为批量操作。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)