Meiji,

> Firebird support SQL statement 'RECREATE TABLE' from version 1.x.
> What is the RECREATE TABLE advantage compare to DROP TABLE and CREATE TABLE.
> I think there is some reason to support RECREATE TABLE, but I cannot find the reason.

With DROP TABLE & CREATE TABLE you can encounter several problems

* you can't drop table if there are some dependencies
* the new table will get new relation id (their maximal number is limited)
* you will loose grants granted to that table
* you will get exception if the table does not exist when executing DROP TABLE

The statement RECREATE TABLE solves only the the last problem,
i.e. it will succeed even if the table does not exist.

Ivan
http://www.volny.cz/iprenosil/interbase/