Your Comments.

• # re: drop object sql

  Roy,
  
  Dumb question... SQL Server 2005 handles a drop like
  
  IF EXISTS (
  SELECT *
  FROM INFORMATION_SCHEMA.ROUTINES
  WHERE SPECIFIC_SCHEMA = N'<Schema_Name, sysname, Schema_Name>'
  AND SPECIFIC_NAME = N'<Procedure_Name, sysname, Procedure_Name>'
  )
  DROP PROCEDURE <Schema_Name, sysname, Schema_Name>.<Procedure_Name, sysname, Procedure_Name>
  GO
  
  by Default. How is you example figuring out the correct object to drop just by name? Is Object_ID in your example a built in function?
  
  Thanks,
  Dennis

  Left by dbottjer at 3/15/2007 4:30 PM
• # re: drop object sql

  yeah, it's a built in function. you can also feed it an optional parameter that will give you that object type. bol has good info on that function.
  
  from what i can tell, this method is faster than the existence check as well. i'll blog about it.

  Left by royashbrook at 3/16/2007 8:21 PM
• # object_id vs exists performance comparison

  

  Left by drowningintechnicaldebt.com at 3/16/2007 8:54 PM

Your Reply.

Comment Form.

Fields denoted with a "*" are required.

*Your name:

*Subject:

You may also like to leave your email or website.

Your blog:

Your email:  (will not be displayed)

*Your message:
 

Please add 3 and 8 and type the answer here:

Enter the code shown above:

Preview Your Comment.