Re: stored procs

On 09/28/11 6:33 PM, J.V. wrote:
> Is is possible within a stored procedure to read all the tables in a
> schema into a list?
>
> From that list and for each table is it possible to find the foreign
> keys in that table?
>
> From that list of foreign keys, is it possible to find out which field
> in which table the FK corresponds to?
>
> I need to extract this meta-data for a project.
>

that metadata should all be available in the information_schema.





--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast