{ |<auto_option>|<change_tracking_option>|<cursor_option>|<database_mirroring_option>|<date_correlation_optimization_option>|<db_encryption_option>|<db_state_option>|<db_update_option>|<db_user_access_option>|<delayed_durability_option>|<external_access_option>|<FILESTREAM_options>|<HADR_...
[isdone])SELECTdatabase_id,name,0FROMmaster.sys.databases (NOLOCK)WHEREis_read_only =0ANDstate =0;DECLARE@dbidINT, @queryVARCHAR(1000), @dbname sysname, @fgname sysnameWHILE(SELECTCOUNT(id)FROM#tmpdbsWHEREisdone =0) >0BEGINSELECTTOP1@dbname = [dbname], @dbid = [dbid]FROM#tmpdbsWHERE...
{ LOCAL | GLOBAL } } <database_mirroring_option> ALTER DATABASE Database Mirroring <date_correlation_optimization_option> ::= DATE_CORRELATION_OPTIMIZATION { ON | OFF } <db_encryption_option> ::= ENCRYPTION { ON | OFF | SUSPEND | RESUME } <db_state_option> ::= { ONLINE | OFFLINE |...
如果 ALTER DATABASE 语句被取消,则数据库仍保持 ALTER DATABASE 开始时所处的状态。 sys.databases 目录视图指示数据库中快照隔离事务的状态。 如果 snapshot_isolation_state_desc = IN_TRANSITION_TO_ON,则命令 ALTER DATABASE ... ALLOW_SNAPSHOT_ISOLATION OFF 暂停6 秒并重试操作。 如果数据库处于 OFFLINE...
CREATE DATABASE for information on creating a database Prerequisites You must have the ALTER DATABASE system privilege. To specify the startup_clauses, you must also be connected AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG. To specify the general_recovery clause, you must also ...
Syntax for SQL Server, Azure SQL Database, and Azure SQL Managed Instance.syntaxsql Copy ALTER INDEX { index_name | ALL } ON <object> { REBUILD { [ PARTITION = ALL [ WITH ( <rebuild_index_option> [ , ...n ] ) ] ] | [ PARTITION = partition_number [ WITH ( <single_partition...
Data Definition: CREATE, DROP, ALTER CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASE creates a database with the given name. Rules for allowable database names … - Selection from MySQL Reference Manual [Book]
This parameter recovers the database to the time specified by the date. The date must be a character literal in the format 'YYYY-MM-DD:HH24:MI:SS'. CHANGE indicates change-based recovery. This parameter recovers the database to a transaction-consistent state immediately before the system ...
SYS_DATASHARE_USAGE_PRODUCER SYS_EXTERNAL_QUERY_DETAIL SYS_EXTERNAL_QUERY_ERROR SYS_INTEGRATION_ACTIVITY SYS_INTEGRATION_TABLE_ACTIVITY SYS_INTEGRATION_TABLE_STATE_CHANGE SYS_LOAD_DETAIL SYS_LOAD_ERROR_DETAIL SYS_LOAD_HISTORY SYS_MV_REFRESH_HISTORY SYS_MV_STATE SYS_PROCEDURE_CALL SYS_PROCEDURE_MESSAGE...
DatabaseEncryptionKeyExtender DatabaseEncryptionState DatabaseEncryptionType DatabaseEvent DatabaseEventArgs DatabaseEvents DatabaseEventSet DatabaseEventType DatabaseFile DatabaseFileMappingsDictionary DatabaseMaintenanceAdapter DatabaseMapping DatabaseMirroringPayload DatabaseObjectTypes DatabaseOptions D...