No, there's no better solution for actually clearing the contents of a table.
Some people use a new table name when they do this. (If your code does something like ListTables("MyTableName").First() to get the first table that starts with that string, then you can "clear" the table by deleting the existing one and creating a
new one called "MyTableName2" or "MyTableName_<guid>".)
Marked As Answer byKevinGZMonday, December 20, 2010 4:24 AM