drop all tables from sql ce database

Question

Is it possible to executa a command which drops all tables from sql ce database ?

thanks for help

Answer 1

You can use information SCHEMA to generate a script:

select 'drop table ' || table_name || ';'
  from information_schema.tables;

Then run that script. You might need to run the script several times, since there is no CASCADE option (AFAIK) in SQLCE.