Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric This topic describes how to rename a stored procedure in SQL Server by using SQL Server Management Studio or Transact-SQL. In This Topic Before you begin: Limitations and Restrictio...
Renaming a stored procedure, function, view, or trigger won't change the name of the corresponding object either in the definition column of the sys.sql_modules catalog view or obtained using the OBJECT_DEFINITION built-in function. Therefore, we recommend that sp_rename not be used to rename...
if(@objtypeis null)beginCOMMITTRANSACTIONraiserror(15225,-1,-1,@objname,@CurrentDb,@objtypeIN)return1end 参考资料: https://docs.microsoft.com/zh-cn/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-2017...
Msg 15225, Level 11, State 1, Procedure sp_rename, Line 437 No item by the name of 'ErrorLog.DF_ErrorLog_ErrorTime' could be found in the current database 'AdventureWorks2014', given that @itemtype was input as '(null)'. 注意:重命名约束时,不能在约束前面加上表对象。正确的方式为:前...
To rename a stored procedure See Also New: 5 December 2005This topic describes how to rename a stored procedure by using Object Explorer in SQL Server Management Studio.Important Changing the name or definition of a stored procedure can cause dependent objects to fail when the objects are not ...
if(@objtypeisnull) begin COMMITTRANSACTION raiserror(15225,-1,-1,@objname,@CurrentDb,@objtypeIN) return1 end 参考资料: https://docs.microsoft.com/zh-cn/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-2017...
sp_renameis a built-in stored procedure which helps to rename user tables in the SQL Server. ...
sp_renameis a built-in stored procedure which helps to rename user tables in the SQL Server. ...
When you rename a stored procedure, function, view, or trigger with sp_rename, the name of the corresponding object doesn't change in the definition column of the sys.sql_modules catalog view. This can lead to future confusion. Therefore, we don't recommend using sp_rename to rename object...
DROP PROCEDURE IF EXISTS `test`.`TestProc`; CREATE PROCEDURE `test`.`TestProc` () BEGIN END; ALTER PROCEDURE TestProc NAME = TestProc2; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NAME = Test...