Reset Database to default/initial state

[samvb]

What would be the easiest way to reset a database to its initial state? TRUNCATE all tables is one option but then the problem with FK constraints is there. DELETE takes a lot of process while DROP CREATE takes a lot as well.

The database usually have close to 300,000 records and a simple way to reset it is needed.

[NeoPa]

I expect DROP/CREATE is the best you'll get I'm afraid.

Listen out for more though, as there may be something I'm just unaware of.