Transact-SQL 語法慣例 語法 SQL Server、Azure SQL 資料庫 和 Azure SQL 受控執行個體 的語法。 syntaxsql 複製 ALTER INDEX { index_name | ALL } ON <object> { REBUILD { [ PARTITION = ALL [ WITH ( <rebuild_index_option> [ , ...n ]
適用於:SQL ServerAzure SQL 資料庫Azure SQL 受控執行個體 將Transact-SQL 與查詢處理行為,設定為相容於指定的 SQL 引擎版本。 如需其他 ALTER DATABASE 選項,請參閱 ALTER DATABASE。 如需語法慣例的詳細資訊,請參閱 Transact-SQL 語法慣例。 語法 syntaxsql 複製 ALTER DATABASE database_name SET ...
syntaxsql コピー ALTER TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } { ALTER COLUMN column_name { [ type_schema_name. ] type_name [ ( { precision [ , scale ] } ) ] [ COLLATE collation_name ] [ NULL | NOT NULL ] } | ALTER INDEX inde...
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 這是要放在指定...
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...
-- 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...
更改column_name 列的说明。 comment 必须为 STRING 文本。 FIRST 或AFTER 标识符 将列从当前位置移到前面(FIRST)或紧邻 AFTER 之后(identifier)。只有 table_name 为Delta 表时才支持此子句。 TYPE data_type 适用于 Databricks SQL Databricks Runtime 15.2 及更高版本 更改column_name 列的数据类型...
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...