如何在SQL Server中删除多个表，如％…％

Try
    Dim MyCommand As New Odbc.OdbcCommand(\"\", MyConnection)
    MyCommand.CommandText = \"drop from sys.tables where tabname like \'% \" & span & \"%\'\"
    Dim result As Integer = MyCommand.ExecuteNonQuery
    MyCommand.Dispose()
Catch ex As Exception
End Try

DROP TABLE tablename

DROP

Using MyCommand As New Odbc.OdbcCommand(\"drop table foo;\", MyConnection)
    MyCommand.ExecuteNonQuery()  
End Using

MyCommand.commandText = \"Drop Table \'\" & tableName & \"\'\"