gruber gruber - 3 months ago 18
SQL Question

drop all tables from sql ce database

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

thanks for help

Answer

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.