Re: table relationships

Jeff wrote:

> When you connect to an Oracle database with Access and ADO, is there a way
> to get information on the Oracle table relationships?
>
> Jeff

Query the data dictionary views. Run this query for a list of them.

SELECT view_name
FROM all_views
WHERE view_name LIKE 'ALL%';

But why connect to Oracle with MS Access? An overwhelming desire to use the worst possible tool to do the job?

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