ok cool I will try that.<br><br>Thanks, Jeremy<br><br><div class="gmail_quote">On Tue, Jun 16, 2009 at 2:54 PM, Edward Koryagin <span dir="ltr"><<a href="mailto:ed_iv2001@yahoo.co.nz">ed_iv2001@yahoo.co.nz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
select * from rdb$relations ...<br>
and<br>
DROP TABLE ....<br>
Edward Koryagin<br>
<br>
<br>
--- On Tue, 16/6/09, Jeremy Coulter <<a href="mailto:jscoulter@gmail.com">jscoulter@gmail.com</a>> wrote:<br>
<br>
> From: Jeremy Coulter <<a href="mailto:jscoulter@gmail.com">jscoulter@gmail.com</a>><br>
> Subject: [DUG] Drop table in Interbase<br>
> To: "NZ Borland Developers Group - Delphi List" <<a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a>><br>
> Received: Tuesday, 16 June, 2009, 1:31 PM<br>
<div><div></div><div class="h5">> Hi all.<br>
> In interbase, how do I drop a table if it already exists?<br>
> I want to check for a table exists and if it does exist,<br>
> drop it.<br>
><br>
> I have Googled, but I cant seem to find anything. I am<br>
> prob. searching wrong :-)<br>
><br>
><br>
> Jeremy<br>
><br>
><br>
</div></div>> -----Inline Attachment Follows-----<br>
><br>
> _______________________________________________<br>
> NZ Borland Developers Group - Delphi mailing list<br>
> Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
> Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
> Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a><br>
> with Subject: unsubscribe<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
</blockquote></div><br>