SQL 复制 -- Rename the Fname column of the customer table RENAME OBJECT::Customer COLUMN FName TO FirstName; RENAME OBJECT mydb.dbo.Customer COLUMN FName TO FirstName; 后续步骤sp_renamedb ALTER DATABASE(Azure SQL 数据库)反馈 此页面是否有帮助? 是 否 提供产品反馈 | 在Microsoft Q&A 获取...
SQL USEAdventureWorks2022; GO EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN'; GO C. 重新命名索引 下列範例會將IX_ProductVendor_VendorID索引重新命名為IX_VendorID。 SQL USEAdventureWorks2022; GO EXEC sp_rename N'Purchasing.ProductVendor.IX_ProductVendor_VendorID', N'IX_Ve...
syntaxsql 复制 sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' [ , [ @objtype = ] 'OBJECT' ] 参数 [ @objname = ] 'object_name' 用户对象或数据类型的当前限定或非限定名称。 如果要重命名的对象是表中的列, object_name 必须位于 form table....
SQL コピー CREATE TABLE table1 (c1 INT, c2 INT); EXEC sp_rename 'table1.c1', 'col1', 'COLUMN'; GO H. オブジェクトの名前を変更する 次の例では、dbo.table1型を使用して、テーブルdbo.table2の名前をOBJECTに変更します。 SQL コピー EXEC sp_rename @objname = 'dbo.table1...
Package: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0 The data type of the column. C# 複製 public Microsoft.SqlServer.TransactSql.ScriptDom.DataTypeReference DataType { get; set; } Property Value DataTypeReference Applies to 產品版本 Microsoft.SQLServer.DacFx 140.3881.1,...
Renames a user-created table, a column in a user-created table or database in Analytics Platform System (PDW). This article applies to Azure Synapse Analytics and Analytics Platform System (PDW) only: To rename a database in SQL Server, use the stored procedure sp_renamedb. To rename a ...
SQL USEAdventureWorks2022; GO EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN'; GO C. 重新命名索引 下列範例會將IX_ProductVendor_VendorID索引重新命名為IX_VendorID。 SQL USEAdventureWorks2022; GO EXEC sp_rename N'Purchasing.ProductVendor.IX_ProductVendor_VendorID', N'IX_Ve...
syntaxsql sp_rename[ @objname = ]'object_name', [ @newname = ]'new_name'[ , [ @objtype = ]'OBJECT'] Arguments [@objname= ] 'object_name' The current qualified or nonqualified name of the user object or data type. If the object to be renamed is a column in a table,object_...
(NAME= test1dat3, FILENAME ='C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\t1dat3.ndf',SIZE=5MB,MAXSIZE=100MB, FILEGROWTH =5MB ), (NAME= test1dat4, FILENAME ='C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\t1dat4.ndf',SIZE=5MB,MAX...
ALTERTABLEdbo.doc_exaADDcolumn_bVARCHAR(20)NULL, column_cINTNULL; 2、删除列 ALTERTABLEdbo.doc_exbDROPCOLUMNcolumn_b; 3、重命名列 EXECsp_rename'Sales.SalesTerritory.TerritoryID','TerrID','COLUMN'; 约束 1、主键 --在现有表中创建主键ALTERTABLEProduction.TransactionHistoryArchiveADDCONSTRAINTPK_Transa...