Re: generate table list

Frank Dietrich wrote:

> Hello all,
>
> is it possible to generate an list with all tables and their
> constraints, triggers, primary keys?
>
> Or in which tables I can found the needed informations?
>
> like
>
> select table_name, trigger_name, triggering_event
> from user_triggers;
>
> Frank

No in a single query unless you use UNION/UNION ALL

And I don't think it is worth the effort.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)