Subject RE: [firebird-support] Drop meta data statements
Author Martin Catherall
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



Check out <>
Ubique --> "Drives Your Business"

PO Box 22571
25 Carlyle Street
Christchurch <>

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.
Subject: Re: [firebird-support] Drop meta data statements

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

>Is it possible to create the following statements with IB
EXPERT (or any
>other admin tools)
>drop referential integrety constraints.

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?



Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <> .

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]