• Here is another method;

    Create a stored proc in each DB to delete the empty tables and then exec that SP by using sp_MsForEachDB.

    Susantha