Using Transact-SQL To rename an index In Object Explorer, connect to an instance of Database Engine. On the Standard bar, click New Query. Copy and paste the following example into the query window and click Ex
Applies to: SQL ServerYou can rename any query that is not currently open for editing. The following procedure assumes that the query you want to rename is closed.To rename a queryFrom the View menu, choose Solution Explorer. In Solution Explorer, right-click the query you want to rename ...
In-Memory OLTP Partitions Plan guides Query Store Query Tuning Assistant Resource governor Statistics Statistics Create Modify Delete View Properties Rename Update Query data Reporting & Analytics Security Tools Tutorials SQL Server on Linux SQL on Azure ...
sp_rename是一个存储过程，可帮助重命名SQL Server中的表，用法语法如下所示：sp_rename 'old_table_n...
Modify the procedure name referenced in any dependent objects or scripts. Using Transact-SQL To rename a stored procedure Connect to the Database Engine. From the Standard bar, click New Query. Copy and paste the following example into the query window and click Execute. This examp...
Use the following steps to rename an Azure SQL database using T-SQL in SQL Server Management Studio. Connect to the master database for your instance. Open a query window. Make sure that no one is using the database. Copy and paste the following example into the query window and select...
The following example renames theSalesTerritorytable toSalesTerrin theSalesschema. Copy and paste the following example into the query window and selectExecute. SQL USEAdventureWorks2022; GO EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr'; ...
2 rows in set (0.003 sec) 如果重命名的列上建有索引,或者有外键约束,rename column可以正常执行,并且索引定义和外键约束会自动级联联修改,比如: OceanBase(root@test)>create table t1 (a int, b int, index idx_a(a)); Query OK, 0 rows affected (0.057 sec) ...
Now, if you query INFORMATION_SCHEMA again, replacing account with items, this is the result: | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | |---|---|---|---| | rextester | dbo | dbo.DimItemsTime | BASE TABLE | | rextester | dbo | dbo.FactItems | BASE TABLE ...
The following example renames theSalesTerritorytable toSalesTerrin theSalesschema. Copy and paste the following example into the query window and selectExecute. SQL USEAdventureWorks2022; GO EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr'; ...