--- In firebird-support@yahoogroups.com, Dennis McFall <dennis@...> wrote:

>
> SQL.Clear;
> SQL.Add( 'SELECT 1 FROM RDB$DATABASE WHERE EXISTS(SELECT
> RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$RELATION_NAME=''SOMETABLE') ');

Yes, that is pretty much what I am doing now - ie doing it all in Delphi.

I had been hoping I could do it all in Firebird SQL, which was the whole point of my question. So much more elegant.

But no problems, I seem to be on the right path then....