Hi,
Bwelow SQL gets the number of fields in "Table1", which equals 0 is table is
not found in database.
SELECT
COUNT(*) RESULT
FROM
RDB$RELATION_FIELDS
WHERE
RDB$RELATION_NAME = 'Table1'
regards,
Vishak
----- Original Message -----
From: soonhuat ong
To: [email protected]
Sent: Monday, June 27, 2005 12:30 PM
Subject: [delphi-en] 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
[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/
