ALTER DATABASE DATABASE_NAME SET ANSI_NULL_DEFAULT ON|OFF --ANSI NULL默认值
GO
ALTER DATABASE DATABASE_NAME SET ANSI_NULLS ON|OFF --ANSI NULLS已启用
GO
ALTER DATABASE DATABASE_NAME SET ANSI_PADDING ON|OFF --ANSI填充已启用
GO
ALTER DATABASE DATABASE_NAME SET ANSI_WARNINGS ON|OFF --ANSI警告已启用
GO
ALTER DATABASE DATABASE_NAME SET ARITHABORT ON|OFF --算术中止已启用
GO
ALTER DATABASE DATABASE_NAME SET AUTO_CLOSE ON|OFF --自动关闭
GO
ALTER DATABASE DATABASE_NAME SET AUTO_CREATE_STATISTICS ON|OFF --自动创建统计信息
GO
ALTER DATABASE DATABASE_NAME SET AUTO_SHRINK ON|OFF --自动收缩
GO
ALTER DATABASE DATABASE_NAME SET AUTO_UPDATE_STATISTICS ON|OFF --自动更新统计信息
GO
ALTER DATABASE DATABASE_NAME SET CURSOR_CLOSE_ON_COMMIT ON|OFF --提交时关闭游标功能已启用
GO
ALTER DATABASE DATABASE_NAME SET CURSOR_DEFAULT GLOBAL|LOCAL --默认游标
GO
ALTER DATABASE DATABASE_NAME SET CONCAT_NULL_YIELDS_NULL ON|OFF --串联的NULL结果为NULL
GO
ALTER DATABASE DATABASE_NAME SET NUMERIC_ROUNDABORT ON|OFF --数值舍入中止
GO
ALTER DATABASE DATABASE_NAME SET QUOTED_IDENTIFIER ON|OFF --允许带引号的标识符
GO
ALTER DATABASE DATABASE_NAME SET RECURSIVE_TRIGGERS ON|OFF --递归触发器已启用
GO
ALTER DATABASE DATABASE_NAME SET ENABLE_BROKER|DISABLE_BROKER --数据库启动|禁用 Service Broker
GO
ALTER DATABASE DATABASE_NAME SET AUTO_UPDATE_STATISTICS_ASYNC ON|OFF --自动异步更新统计信息
GO
ALTER DATABASE DATABASE_NAME SET DATE_CORRELATION_OPTIMIZATION ON|OFF --日期相关性优化已启动
GO
ALTER DATABASE DATABASE_NAME SET TRUSTWORTHY ON|OFF --可信
GO
ALTER DATABASE DATABASE_NAME SET ALLOW_SNAPSHOT_ISOLATION ON|OFF --事务可以指定 SNAPSHOT 事务隔离级别
GO
ALTER DATABASE DATABASE_NAME SET PARAMETERIZATION SIMPLE|FORCED --参数化
GO
ALTER DATABASE DATABASE_NAME SET READ_WRITE|READ_ONLY --数据库为只读
GO
ALTER DATABASE DATABASE_NAME SET RECOVERY FULL|BULK_LPGGED|SIMPLE --恢复模式
GO
ALTER DATABASE DATABASE_NAME SET MULTI_USER|SINGLE_USER|RESTRICTED_USER --限制访问
GO
ALTER DATABASE DATABASE_NAME SET PAGE_VERIFY CHECKSUM|TORNPAGEDETECTION --页验证
GO
ALTER DATABASE DATABASE_NAME SET DB_CHAINING ON|OFF --跨数据库所有权链接已启用
ALTER DATABASE database_name
{ <add_or_modify_files>
| <add_or_modify_filegroups>
| <set_database_options>
| MODIFY NAME = new_database_name
| COLLATE collation_name
} [;]
<add_or_modify_files>::=
{ ADD FILE <filespec> [ ,...n ] [ TO FILEGROUP { filegroup_name } ]
| ADD LOG FILE <filespec> [ ,...n ]
| REMOVE FILE logical_file_name
| MODIFY FILE <filespec>
}
<filespec>::=
( NAME = logical_file_name
[ , NEWNAME = new_logical_name ]
[ , FILENAME = 'os_file_name' ]
[ , SIZE = size [ KB | MB | GB | TB ] ]
[ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ]
[ , FILEGROWTH = growth_increment [ KB | MB | GB | TB| % ] ]
[ , OFFLINE ]
)
<add_or_modify_filegroups>::=
{
| ADD FILEGROUP filegroup_name
| REMOVE FILEGROUP filegroup_name
| MODIFY FILEGROUP filegroup_name
{ <filegroup_updatability_option>
| DEFAULT
| NAME = new_filegroup_name
}
}
<filegroup_updatability_option>::=
{ { READONLY | READWRITE }
| { READ_ONLY | READ_WRITE }
}
<set_database_options>::=SET {{ <optionspec> [ ,...n ] [ WITH <termination> ] } }
<optionspec>::=
{ <db_state_option>
| <db_user_access_option>
| <db_update_option>
| <external_access_option>
| <cursor_option>
| <auto_option>
| <sql_option>
| <recovery_option>
| <database_mirroring_option>
| <service_broker_option>
| <date_correlation_optimization_option>
| <parameterization_option> }
<db_state_option> ::= { ONLINE | OFFLINE | EMERGENCY }
<db_user_access_option> ::= { SINGLE_USER | RESTRICTED_USER | MULTI_USER }
<db_update_option> ::= { READ_ONLY | READ_WRITE }
<external_access_option> ::= { DB_CHAINING { ON | OFF } | TRUSTWORTHY { ON | OFF } }
<cursor_option> ::= { CURSOR_CLOSE_ON_COMMIT { ON | OFF } | CURSOR_DEFAULT { LOCAL | GLOBAL } }
<auto_option> ::=
{ AUTO_CLOSE { ON | OFF }
| AUTO_CREATE_STATISTICS { ON | OFF }
| AUTO_SHRINK { ON | OFF }
| AUTO_UPDATE_STATISTICS { ON | OFF }
| AUTO_UPDATE_STATISTICS_ASYNC { ON | OFF }
}
<sql_option> ::=
{ ANSI_NULL_DEFAULT { ON | OFF }
| ANSI_NULLS { ON | OFF }
| ANSI_PADDING { ON | OFF }
| ANSI_WARNINGS { ON | OFF }
| ARITHABORT { ON | OFF }
| CONCAT_NULL_YIELDS_NULL { ON | OFF }
| NUMERIC_ROUNDABORT { ON | OFF }
| QUOTED_IDENTIFIER { ON | OFF }
| RECURSIVE_TRIGGERS { ON | OFF }
}
<recovery_option> ::=
{ RECOVERY { FULL | BULK_LOGGED | SIMPLE }
| TORN_PAGE_DETECTION { ON | OFF }
| PAGE_VERIFY { CHECKSUM | TORN_PAGE_DETECTION | NONE }
}
<database_mirroring_option> ::= { <partner_option> | <witness_option> }
<partner_option> ::=
PARTNER { = 'partner_server'
| FAILOVER
| FORCE_SERVICE_ALLOW_DATA_LOSS
| OFF
| RESUME
| SAFETY { FULL | OFF }
| SUSPEND
| TIMEOUT integer
}
<witness_option> ::= WITNESS { = 'witness_server' | OFF }
<service_broker_option> ::= {ENABLE_BROKER | DISABLE_BROKER | NEW_BROKER | ERROR_BROKER_CONVERSATIONS }
<date_correlation_optimization_option> ::= { DATE_CORRELATION_OPTIMIZATION { ON | OFF } }
<parameterization_option> ::= { PARAMETERIZATION { SIMPLE | FORCED } }
<snapshot_option> ::= { ALLOW_SNAPSHOT_ISOLATION {ON | OFF } | READ_COMMITTED_SNAPSHOT {ON | OFF } }
<termination> ::= { ROLLBACK AFTER integer [ SECONDS ] | ROLLBACK IMMEDIATE | NO_WAIT }
---------------------
作者：usher_gml
来源：CSDN
原文：https://blog.csdn.net/usher_gml/article/details/4357145
版权声明：本文为博主原创文章，转载请附上博文链接！
