Hi helen,

thanks for the reply.

I'm sorry I was not clear, I wasn't actually asking for the syntax, I'm
familar with that (even though I come from the MSSQL world -- which is a
little different).

My problem is this.

IBEXPERT can generate create statements for sp's triggers tables ect,
which is great, but I also need a script to remove these tables.
I want to simply remove a set of objects from a database and NOT drop
the entire database.
I have created a small set of objects (tables / sps / triggers ect)
within a larger database and I would like to generate scripts for these.
I have manually ammended some of the output of the meta data wizard in
IBEXPERT so that I have the neccessary script, but it is a really pain
having to manually alter this each time I add a new database object.

sorry about the confusion

cheers

martin.






Check out www.ubique.webscape.co.nz <http://www.ubique.webscape.co.nz/>
Ubique --> "Drives Your Business"

W E B S C A P E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz <http://www.webscape.co.nz/>

Phone 03 964 4020
Fax 03 365 9115
Email mc@... <mailto:tmc@...>

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, 19 January 2005 3:39 p.m.
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Drop meta data statements


At 03:01 PM 19/01/2005 +1300, you wrote:

>Hi,
>
>Is it possible to create the following statements with IB

EXPERT (or any

>other admin tools)
>
>drop referential integrety constraints.

ALTER TABLE
DROP CONSTRAINT <constraint-name>

But it won't work if the constraint has other constraints
depending on it,
e.g. a PH has foreign keys pointing to it.

>drop procedures

DROP PROCEDURE <procedure-name>

>drop generators

DROP GENERATOR <generator-name> (Firebird only)

>drop triggers

DROP TRIGGER <trigger-name>

Have you thought about bookmarking a standard SQL reference?

./hb




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .



=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server


[Non-text portions of this message have been removed]