Subject | Re: Select * from where 0=1 |
---|---|
Author | diwic2 |
Post date | 2004-03-24T11:40:23Z |
> The problem with this statement is that it forces me to know a bittoo much
> about the table :If you want to figure out the field names and types of a table, I
> a column name and a non-existing value.
>
> Ideally, I'd need something more generic.
> Any other hint ?
think you should query the system table RDB$RELATION_FIELDS.
select * from RDB$RELATION_FIELDS where RDB$RELATION_NAME = <name of
table>
// David