Thanks for looking at the test and make me correct.
In this patch I break the test into several methods,
Also I compared it with the DropTable.out file for any missing tests. I
found that there are some repeated tests and I removed them. I think now the
test can be committed as a patch. Please let me know your view about this.