SQL Server、Azure SQL 資料庫 和 Azure SQL 受控執行個體 的語法。 syntaxsql 複製 ALTER INDEX { index_name | ALL } ON { REBUILD { [ PARTITION = ALL [ WITH ( <rebuild_index_option> [ , ...n ] ) ] ] | [ PARTITION = partition_number [ WITH ( <single_partition_rebuild_index_opt...
-- SQL Server Syntax ALTER DATABASE { database_name | CURRENT } { MODIFY NAME = new_database_name | COLLATE collation_name | <file_and_filegroup_options> | SET [ ,...n ] [ WITH <termination> ] } [;] <file_and_filegroup_options>::= <add_or_modify_files>::= <filespec>:...
Transact-SQL 语法约定 备注 Microsoft Entra ID 以前称为 Azure Active Directory (Azure AD)。 语法 syntaxsql 复制 -- Syntax for SQL Server ALTER AUTHORIZATION ON [ <class_type>:: ] entity_name TO { principal_name | SCHEMA OWNER } [;] <class_type> ::= { OBJECT | ASSEMBLY | ASYMMETRIC...
SQL Server Syntax for SQL Server syntaxsql Copy ALTER LOGIN login_name { <status_option> | WITH <set_option> [ , ... ] | <cryptographic_credential_option> } [;] <status_option> ::= ENABLE | DISABLE <set_option> ::= PASSWORD = 'password' | hashed_password HASHED [ OLD_PASSWORD...
* SQL Server * SQL 数据库 Microsoft Fabric SQL 托管实例 Azure Synapse 分析 分析平台 系统(PDW) SQL Server 语法 syntaxsql -- Syntax for SQL ServerALTERUSERuser_nameWITH<set_item>[ ,...n ] [;]<set_item>::=NAME=new_user_name|DEFAULT_SCHEMA= {schema_name|NULL} |LOGIN=login_name|PASSWO...
-- Syntax for SQL Server, Azure SQL Database and Azure SQL Managed Instance ALTER DATABASE SCOPED CONFIGURATION { { [ FOR SECONDARY] SET <set_options>} } | CLEAR PROCEDURE_CACHE [plan_handle] | SET < set_options > [;] < set_options > ::= { MAXDOP = { <value> | PRIMARY} | L...
Dies ändert die Eigenschaften eines Volltextindex in SQL Server.Transact-SQL-SyntaxkonventionenSyntaxsyntaxsql Kopieren ALTER FULLTEXT INDEX ON table_name { ENABLE | DISABLE | SET CHANGE_TRACKING [ = ] { MANUAL | AUTO | OFF } | ADD ( column_name [ TYPE COLUMN type_column_name ] [ ...
Syntax for SQL Server, Azure SQL Database, and Azure SQL Managed Instance. syntaxsql Copy ALTER INDEX { index_name | ALL } ON { REBUILD { [ PARTITION = ALL [ WITH ( <rebuild_index_option> [ , ...n ] ) ] ] | [ PARTITION = partition_number [ WITH ( <single_partition_rebuild...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Changes the ownership of a securable. Transact-SQL syntax conventions ...
syntaxsql 複製 ALTER DATABASE { database_name | CURRENT } SET { [ ,...n ] [ WITH <termination> ] } ::= { <accelerated_database_recovery> | <auto_option> | <automatic_tuning_option> | <change_tracking_option> | <containment_opti...