| Subject | Re: How to check if table exists?! |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2005-04-20T08:45:02Z |
select 'Help, I exist!'
from rdb$relations
where rdb$relation_name = 'YourTable'
will tell you whether there exists a table or a view with the name
'YourTable'. Though I don't know how to separate views from tables if
you are spesifically looking for tables.
HTH,
Set
from rdb$relations
where rdb$relation_name = 'YourTable'
will tell you whether there exists a table or a view with the name
'YourTable'. Though I don't know how to separate views from tables if
you are spesifically looking for tables.
HTH,
Set
--- In firebird-support@yahoogroups.com, "matijamikac" wrote:
> How can I check if table exists in database using SQL?!
> Is it possible using some system tables?