Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    91

    Unanswered: delete a stored proc

    Hi everyone -

    What is the syntax to drop a stored procedure?

    In my script, i would like to delete the existing
    stored proc prior to creating a new one...

    thanks

    take care
    tony

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    drop procedure <foo>
    Thanks,

    Matt

  3. #3
    Join Date
    Oct 2004
    Posts
    91

    Yup

    That was the ticket -

    if exists(select * from sysobjects where type = 'P' and name = 'xprocDischargePatientByClass') drop procedure xprocDischargePatientByClass;


    thanks for the post!!


    take care
    tony
    Last edited by alt-088; 10-20-05 at 10:57.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •