Ask the Expert

Dropping two tables with a single drop table statement

drop table table1,table2;

I want to drop two tables in a single drop table statement.

    Requires Free Membership to View

Unfortunately, you cannot do this in one statement. I'm not sure why this is required, but if you absolutely need one statment, then you'll have to code a stored procedure to do your drop commands one at a time. Then execute the stored proc in one statement.

This was first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: