CODEWITHSUNDEEP
sqlsql-server-ce
Mike Baxter
Mike Baxter

Reputation: 7248

Drop a selection of tables

I'm aware of the commands for dropping a single table or all tables. But in this scenario I need to be able to drop a selection of tables in SQL CE. I know it is possible to do this logic on the application level but I was wondering if it was possible to do this in a single SQL command? I have been unable to find out an answer to this question elsewhere.

I have previously attempted:

drop table table1, table2, table3

But this did not work. Is it possible to do this in a single command?

Upvotes: 0

Views: 55

Answers (1)

ErikEJ
ErikEJ

Reputation: 41749

No, it is not possible in a single statement: http://msdn.microsoft.com/en-us/library/ms173418.aspx

Upvotes: 1

Related Questions