I am converting a sql database to firebird...

I cannot figure out how to check if a object already exists and if it does
drop it

This is my best best but it does not work:

IF exists (select * from RDB$GENERATORS where RDB$GENERATOR_NAME =
'GEN_USEDDS_ID1')
then
drop'GEN_USEDDS_ID1'


Does anyone know how this should be done?
Also if there is a dependency how do I make sure that the objects are all
deleted ?

Many thanks,

David

ib-support@yahoogroups.com

-----Original Message-----
From: firebird-support Moderator
[mailto:firebird-support-owner@yahoogroups.com]
Sent: Tuesday, March 01, 2005 7:18 PM
To: david@...
Subject: Welcome to firebird-support



Hello,

Welcome to the firebird-support group at Yahoogroups, a free, easy-to-use
email group service. Please take a moment to review this message.

To start sending messages to members of this group, simply send email to

firebird-support@yahoogroups.com

If you do not wish to belong to firebird-support, you may unsubscribe by
sending an email to
firebird-support-unsubscribe@yahoogroups.com

You may also visit your home account page on Yahoogroups to modify your
subscriptions:

http://www.yahoogroups.com/mygroups


Regards,

Moderator, firebird-support




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/