| Subject | Re: [firebird-support] Checking if a table exists ... |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-03-31T11:51:59Z |
At 11:33 AM 31/03/2004 +0000, you wrote:
SELECT 1 FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME = ?
SELECT 1 FROM RDB$PROCEDURES
WHERE RDB$PROCEDURE_NAME = ?
Returns 1 if the object exists, null if not.
/hb
>How can I check, inside a stored procedure as well as from anTables and views:
>application, if a specific table or view or procedure or any other
>object exists in the database?
SELECT 1 FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME = ?
SELECT 1 FROM RDB$PROCEDURES
WHERE RDB$PROCEDURE_NAME = ?
Returns 1 if the object exists, null if not.
/hb