Is there a way that I could programmatically ask eclipselink to delete and create all tables?

Question

This helps in unit testing.

Answer 1

The following should work for you:

ServerSession session = entityManager.unwrap(ServerSession.class);  
SchemaManager schemaManager = new SchemaManager(session);  
schemaManager.replaceDefaultTables(true, true);

Answer 2

One way to do this is to execute sql scripts. eclipselink generates an indication:

      <property name="eclipselink.ddl-generation.output-mode" value="both"/>

in persistence.xml