Issue with the IF EXISTS command

Question

I am trying to get this command that is on auto run to have an automatic delete incase I have to re-run the application. I am using visual studio and sql server 2012.

Here is what I have. The Create table works but its the IF EXISTS that I am having trouble with.

IF EXISTS (DROP TABLE ST_BANLIST)

CREATE TABLE ST_BANLIST
(BAN VARCHAR (9).
CALL_ACTIVITY CHAR(1).
BAN_STATUS CHAR(1))

Thanks for any help

Possible duplicate of [How to drop a table if it exists in SQL Server?](http://stackoverflow.com/questions/7887011/how-to-drop-a-table-if-it-exists-in-sql-server) — Daniel Corzo, Dec 27 '16 at 21:00

Code Different · Answer 1 · 2016-12-27T22:37:53.377

1

Your syntax was incorrect:

IF OBJECT_ID('dbo.ST_BANLIST', 'U') IS NOT NULL
    DROP TABLE dbo.ST_BANLIST

SQL Server 2016 makes this a lot easier (what took so long Microsoft?):

DROP TABLE IF EXISTS dbo.ST_BANLIST

edited Dec 27 '16 at 22:37

answered Dec 27 '16 at 21:04

Code Different

90,614
16
144
163

score 0 · Answer 2 · answered Dec 28 '16 at 01:29

0

if exists(select * from  sys.objects where name ='MytableName' and type='U')
    Drop table dbo.MytableName

answered Dec 28 '16 at 01:29

Vigya

122
1
7

Issue with the IF EXISTS command

2 Answers2