Transact-SQL 語法慣例 語法 SQL Server、Azure SQL 資料庫 和 Azure SQL 受控執行個體 的語法。 syntaxsql 複製 ALTER INDEX { index_name | ALL } ON <object> { REBUILD { [ PARTITION = ALL [ WITH ( <rebuild_index_option> [ , ...n ]
syntaxsql 複製 -- Syntax for Azure Synapse Analytics and Parallel Data Warehouse and Microsoft Fabric ALTER VIEW [ schema_name . ] view_name [ ( column_name [ ,...n ] ) ] AS [;] 引數 schema_name 這是檢視所屬的結構描述名稱。 view_name 這是要變更的檢視。 column 這是要放在指定...
syntaxsql 복사 -- Syntax for Azure Synapse Analytics and Parallel Data Warehouse ALTER TABLE { database_name.schema_name.source_table_name | schema_name.source_table_name | source_table_name } { ALTER COLUMN column_name { type_name [ ( precision [ , scale ] ) ] [ COLLATE Windows...
適用於:SQL ServerAzure SQL 資料庫Azure SQL 受控執行個體 將Transact-SQL 與查詢處理行為,設定為相容於指定的 SQL 引擎版本。 如需其他 ALTER DATABASE 選項,請參閱 ALTER DATABASE。 如需語法慣例的詳細資訊,請參閱 Transact-SQL 語法慣例。 語法 syntaxsql 複製 ALTER DATABASE database_name SET ...
-- 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...
Syntax 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...
SQL Server Azure SQL Database Azure SQL Managed Instance Sets Transact-SQL and query processing behaviors to be compatible with the specified version of the SQL engine. For other ALTER DATABASE options, seeALTER DATABASE. For more information about the syntax conven...
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 ...
RENAMECOLUMNold_nametonew_name; To rename a column in a table in SQL Server, use the following syntax: SQL Server: EXECsp_rename'table_name.old_name','new_name','COLUMN'; ALTER TABLE - ALTER/MODIFY DATATYPE To change the data type of a column in a table, use the following syntax:...
Syntax for ALTER TABLE ALTER TABLE table-name 1ADDCOLUMNcolumn-definitionALTERCOLUMNcolumn-alterationRENAME COLUMNsource-column-nameTOtarget-column-nameDROPCOLUMNcolumn-nameRESTRICTADD PERIODFORperiod-definitionADDunique-constraintreferential-constraintcheck-constraint4DROPRPRIMARY KEYUNIQUEFOREIGN KEYCHECKCONSTRAINT...