DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: drop procedure

  1. #1
    Join Date
    Aug 2001
    Posts
    390
    How can I drop a procedure if it's in lower case. is there any trick so I can get rid of it, b/c the regular command to drop procedure is very simple.

    drop procedure


  2. #2
    Join Date
    Jul 2000
    Posts
    521
    use quotation marks around the procedure name.
    svk

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Issue

    drop procedure schema.procedure_name;


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Mar 2001
    Posts
    71
    try double quotes around procedure name.

Posting Permissions

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


Click Here to Expand Forum to Full Width