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 ...
For more information, see Add Data or Log Files to a Database. To change the collation of the database, select the Options page, and then select a collation from the list. To change the recovery model, select the Options page and select a recovery model from the list. To change data...
程序集: Microsoft.SqlServer.TransactSql.ScriptDom(在 Microsoft.SqlServer.TransactSql.ScriptDom.dll 中) 语法 C# 复制 public Identifier Collation { get; set; } 属性值 类型:Microsoft.SqlServer.TransactSql.ScriptDom.Identifier The collation name. 请参阅 参考 CreateDatabaseStatement 类 Microsoft.SqlServ...
syntaxsql Cóipeáil CREATE DATABASE database_name [ CONTAINMENT = { NONE | PARTIAL } ] [ ON [ PRIMARY ] <filespec> [ ,...n ] [ , <filegroup> [ ,...n ] ] [ LOG ON <filespec> [ ,...n ] ] ] [ COLLATE collation_name ] [ WITH <option...
syntaxsql Copy CREATE DATABASE database_name [ CONTAINMENT = { NONE | PARTIAL } ] [ ON [ PRIMARY ] <filespec> [ ,...n ] [ , <filegroup> [ ,...n ] ] [ LOG ON <filespec> [ ,...n ] ] ] [ COLLATE collation_name ] [ WITH <option> [,...n ] ] [;] <option> ::=...
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...
[COLLATE <collation name>] [FOR ATTAH [WITH <service broker>]| FOR ATTACH_REBUILD_LOG| WITH DB_CHAINING ON| OFF | TRUSTWORTHY ON|OFF] [AS SNAPSHOT OF <source database name>] [;] 1. 2. 3. 4. 5. 6. 7. 8. 9. 10.
Create a user with a login Logins in themasterdatabase are common for the people who manage the SQL Server and for people who need to access many or all of the database on the instance of SQL Server. For this situation, create aSQL user with login. The database user is the identity...
在MySQL 中,可以使用 CREATE DATABASE 语句创建数据库,语法格式如下: CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] DB_NAME [CREATE_SPECIFICATION [, CREATE_SPECIFICATION] ...] CREATE_SPECIFICATION: [DEFAULT] CHARACTER SET CHARSET_NAME | [DEFAULT] COLLATE COLLATION_NAME 创建数据库 ...