Subject Re: Select * from where 0=1
Author diwic2
> The problem with this statement is that it forces me to know a bit
too much
> about the table :
> a column name and a non-existing value.
>
> Ideally, I'd need something more generic.
> Any other hint ?

If you want to figure out the field names and types of a table, I
think you should query the system table RDB$RELATION_FIELDS.

select * from RDB$RELATION_FIELDS where RDB$RELATION_NAME = <name of
table>

// David