You cannot delete a stored procedure from SYSOBJECTS system table unless you change the configuration setting of ASE by using sp_configure 'allow updates', 1. To do that, you need to be Sybase system administrator. It is better not to delete from system catalogue tables unless it is absolutely necessary. The proper way of dropping a stored procedure is to issue the following command:
DROP procedure <PROCEDURE_NAME >
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE.continue reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come.continue reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.