Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Removing ESPs [Table of Contents] Executing ESPs

Transact-SQL User's Guide

[-] Chapter 15 Using Extended Stored Procedures
[-] Removing ESPs
[-] Renaming ESPs

Renaming ESPs

Because an ESP name is bound to the name of its function, you cannot rename an ESP using sp_rename, as you can with a stored procedure. To change the name of an ESP:

  1. Remove the ESP with drop procedure or sp_dropextendedproc.

  2. Rename and recompile the supporting function.

  3. Re-create the ESP with the new name using create procedure or sp_addextendedproc.

Removing ESPs [Table of Contents] Executing ESPs