Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Drop a table and views Expand / Collapse
Author
Message
Posted Thursday, June 5, 2008 12:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 19, 2015 3:43 AM
Points: 75, Visits: 137
Comments posted to this topic are about the item Drop a table and views
Post #512386
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: Monday, October 13, 2014 6:16 AM
Points: 4, Visits: 48
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
Posted Tuesday, May 10, 2016 7:01 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, September 22, 2016 6:32 AM
Points: 8,071, Visits: 807
Thanks for the script.
Post #1784703
Posted Tuesday, May 10, 2016 7:01 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, September 22, 2016 6:32 AM
Points: 8,071, Visits: 807
Robert Seliga (7/23/2008)
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
Thanks for that.
Post #1784704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse