Can I delete only tables, or only objects sharing a string of text, from a geodatabase?

Question

I've got about 1000 tables in a geodatabse that I need to delete. They are named IntersectedBuffers_1, IntersectedBuffers_2, etc, and they're the only tables in the database.

Could someone please tell me how to delete these? I've been trying to do it from the python window. I can successfully delete individual tables with the following code:

import arcpy
arcpy.env.workspace = r"C:\Documents and Settings\Administrator\My Documents\ArcGIS\Default1.gdb"
arcpy.Delete_management("IntersectedBuffers_2")

But how can I delete all of them? I've tried things like

arcpy.Delete_management("IntersectedBuffers*.tbl")

... but I'm really just guessing! Is there a way to delete based on a shared text string, or based on teh fact that they're all tables?

Thanks in advance,

Jay

Answer 1

What you have to do is add all of your Tables to a list, and delete the list:

arcpy.env.workspace = r"C:\Documents and Settings\Administrator\My Documents\ArcGIS\Default1.gdb"
lstTables = arcpy.ListTables("IntersectedBuffers*", "All") #all is default

#I cannot remember the delete command, but I think it is this:
for dt in lstTables:
    arcpy.Delete_management(dt)

I think this should work, but am away from my python machine, so will have a look later

Arcpy ListTables