How to alter a stored procedure in Sybase?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 27, 2008 at 8:37 pm

  #93984

  I cannot find any syntax about how to do it in Sybase. What I have to do is

  Delete the stored procedure, then recreate it.

  Anyone knows how to do it in other way, such as ALTER PROC myProc AS ... in TSQL?

  Any input will be greatly appreciated.

• Vivien Xing

  SSChampion

  Points: 12296

  More actions

  February 27, 2008 at 9:04 pm

  #782967

  Drop then create again.

  drop proc[edure] [owner.]procedure_name

  [, [owner.]procedure_name] ...

  "Transact-SQL® User’s Guide"

  http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc32300_1250/html/sqlug/title.htm&toc=/com.sybase.help.ase_12.5/toc.xml

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 28, 2008 at 10:12 am

  #783342

  So, you mean there is no any command similar to SQL Server,

  ALTER PROC ...

  ?

• Vivien Xing

  SSChampion

  Points: 12296

  More actions

  February 28, 2008 at 10:20 am

  #783349

  No as I know.