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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.