>
> Thanks in the end i came up with this:
>
> SELECT *
> FROM RDB$FIELDS
> WHERE( RDB$SYSTEM_FLAG = 0 )
>
> Admin tools are useless when you need to get information
> programatically.

true, of course. you didn't mention that in your first message. And we can
assume you also know the pitfalls of using DDL on a live database.
Alan

>
> Kind Regards,
>
> Robert.