Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Haris Ahmad » Drop a table and views
Add to briefcase

Drop a table and views Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
ahmadharis
Posted Thursday, June 05, 2008 12:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:44 PM
Points: 75, Visits: 128
Comments posted to this topic are about the item Drop a table and views
Post #512386
Robert Seliga
Posted Wednesday, July 23, 2008 7:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 13, 2012 7:05 AM
Points: 4, Visits: 41
save yerself some typing:

if object_id('dbo.table_name') is not null
drop dbo.table_name

toss that at the top of the script too before dropping the sp ahead of the create statement
Post #539222
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.