The following are the required programming constructs for a Sybase procedure file:
:r LeasePak_syb_use go if exists (select * from sysobjects where name = 'up_procedure-name') drop procedure up_procedure-name go create procedure up_procedure-name body of procedure go