SAP Knowledge Base Article - Preview

1983115 - Procedures, triggers, and views that depend on an object whose name has been changed using sp_rename do not require drop/recreate or recompile - SAP ASE

Symptom

In the Adaptive Server Enterprise 15.x Reference Manuals under Chapter Procedures  --> System Procedures, there is a warning message that states the following regarding the sp_rename stored procedure :

WARNING! Procedures, triggers, and views that depend on an object whose name has been changed will no longer work. Change the definitions of any dependent objects before you execute sp_rename. Find dependent objects with sp_depends.

This used to be the case for version 12.5.x, but is no longer the case in version 15.x. Hence, the manual needs updated.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)  15.x All Versions

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Stored Procedure, SP, trigger,view,recompile , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.