Nick Upson wrote:

>> Could you help me how to write this syntax in FB 1.5 Dialect 3 ? (I used to
>> familiar with mySQL)
>>
>> ** DROP TABLE IF EXISTS table_1; **

With Firebird 1.5 you can do it with EXECUTE STATEMENT using some stored
procedure. With Firebird 2.x you can combine EXECUTE STATEMENT and
EXECUTE BLOCK do to everything in a single statement:

See example on this page:

http://www.firebirdfaq.org/faq69/

Just change 'not exists' to 'exists' and 'create' to 'drop' and it will
do what you want.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com