use a query to check if the tablename exists in the table Rdb$Relations
as Mick suggested. The query should return 0 or 1 records where from you can
get the answer you were looking for.

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf
Of Mick Arundell
Sent: Monday, June 27, 2005 11:05 AM
To: [email protected]
Subject: Re: [delphi-en] Digest Number 1473



>
> Message: 3
>    Date: Mon, 27 Jun 2005 00:00:57 -0700 (PDT)
>    From: soonhuat ong <[EMAIL PROTECTED]>
> Subject: Check if a table exist in a database
>
>
> Hi,
>
> I want to check if Table1 exists in Database1 or
> not, if yes return true, else return false. How am i
> goin to do it? For your information, I'm using
> Interbase. Thx in advance
>
Don't have full details with me but
Rdb$Relations contains all table names
Full details are in the docs

mick






____________________________________________________
Do you Yahoo!?
Win a dream trip to Western Australia, courtesy of the NEW My Yahoo!
http://au.my.yahoo.com/


-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]



----------------------------------------------------------------------------
----
YAHOO! GROUPS LINKS

  a..  Visit your group "delphi-en" on the web.

  b..  To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]

  c..  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


----------------------------------------------------------------------------
----




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



-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/delphi-en/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

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



Reply via email to