How to drop multiple tables with common prefix in one query?

20 votes

7 answers

119108 views

sql-server sql-server-2008 drop-table

                          I'm using  Microsoft SQL Server 2008.My question is:How to drop multiple tables with common prefix in one query?

something like that table names:

    LG_001_01_STLINE, 
    LG_001_02_STFICHE

Asked by Cell-o (1106 rep)

Sep 8, 2011, 02:18 PM
Last activity: Jul 5, 2023, 10:56 AM

How to drop multiple tables with common prefix in one query?

Related Questions