Re: any sql statement to list child tables?

From: Jeremy Russell <jeremyr_at_no-spam-today-thanks.dircon.co.uk>
Date: 1998/09/14
Message-ID: <35fd527c.2207211@news.dircon.co.uk>#1/1

Sure, it can be done - off-hand, I don't have the dictionary tables with me but your DB admin manual will list the relevant tables in one of the appendices.

Good luck - post the SQL statement(s) here when you put them together?

Thenardier_at_POBoxes.com wrote:

>
>
>is there any sql statement which can list all the child tables and
>their keys and foriegn keys? ... cos i'm tired of consulting the
>3-inch technical references anymore! :P
>
>thanx in advance!
>
>rgds,
>thenard
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 14 1998 - 00:00:00 CDT