syntaxsql 复制 CREATE DATABASE database_name [ CONTAINMENT = { NONE | PARTIAL } ] [ ON [ PRIMARY ] <filespec> [ ,...n ] [ , <filegroup> [ ,...n ] ] [ LOG ON <filespec> [ ,...n ] ] ] [ COLLATE collation_name ] [ WITH <option> [,...n ] ] [;] <option> ::=...
Database design Hierarchical Data Collation Databases Overview How-to guides Manage Create a database View databases Add data files Manage properties Change configuration settings Delete a database Delete data or log files from a database Display data & log space information for a database Increase ...
CREATE DATABASE命令用于创建一个数据库,创建一个数据库的最基本语法如下所示: CREATE DATABASE <database name> 1. CREATE DATABASE的完整语法 CREATE DATABASE <NewDataBase> [ON [PRIMARY] ([NAME = <'logical file name'>,] FILENAME = <'file name'> [, SIZE = <size in kilobytes,megabytes,gigab...
COLLATE collation_name 指定数据库的默认排序规则。排序规则名称既可以是 Windows 排序规则名称,也可以是 SQL 排序规则名称。如果没有指定排序规则,则将 SQL Server 实例的默认排序规则分配为数据库的排序规则。不能对数据库快照指定排序规则名称。 不能使用 FOR ATTACH 或 FOR ATTACH_REBUILD_LOG 子句指定排序规则名...
For more information about the Windows and SQL collation names, seeCOLLATE (Transact-SQL). FOR ATTACH Specifies that the database is created by attaching an existing set of operating system files. There must be a <filespec> entry that specifies the primary file. The only other <filespec> entr...
CURRENT_REQUEST_ID (Transact-SQL) CURRENT_TIMESTAMP (Transact-SQL) CURRENT_USER (Transact-SQL) cursor (Transact-SQL) CURSOR_STATUS (Transact-SQL) 資料指標 (Transact-SQL) 資料收集器函數 (Transact-SQL) 資料類型 (Transact-SQL) DATABASE_PRINCIPAL_ID (Transact-SQL) ...
Valid values for the Ctype field: You can execute the SELECT DISTINCT collctype FROM pg_collation; statement to obtain the field value. The default value is en_US.utf8. gbk DBDescription string No The description of the database. The description must be 2 to 256 characters in length and ...
create aSQL user with login. The database user is the identity of the login when it connects to a database. The database user can use the same name as the login, but that isn't required. This article assumes that a login already exists in SQL Server. For information about how ...
FIX: Error occurs when you try to create external table in PolyBase with database_default as collation in SQL Server 2019
CURRENT_REQUEST_ID (Transact-SQL) CURRENT_TIMESTAMP (Transact-SQL) CURRENT_USER (Transact-SQL) cursor (Transact-SQL) CURSOR_STATUS (Transact-SQL) 游标(Transact-SQL) 数据收集器函数 (Transact-SQL) 数据类型 (Transact-SQL) DATABASE_PRINCIPAL_ID (Transact-SQL) ...