need to delete bulk insert object to run again

Question

i have a sql script I am supposed to run that starts with:

    BULK INSERT #BridgeVendors
    FROM 'D:\projects\databases\Scripts\Release\6.7.1\BridgeVendors.csv'
    WITH ( FIELDTERMINATOR=',', FIRSTROW = 2 )

the first time I ran it I had the path name going toincorrect path so it didn't execute properly , but now - I can't run it again because I get the error :

There is already an object named '#BridgeVendors' in the database.

How do I UNDO or DELETE this "Object" that was a BULK INSERT??

Answer 1

You just need to drop the table :)

drop table #BridgeVendors