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/

