Re: How do I view the key contraints on Oracle7??

From: Doug Henderson <djhender_at_canuck.com>
Date: 1995/05/16
Message-ID: <3pbd16$dcr_at_mp.canuck.com>#1/1

Roberts_Daniel_g.PRILVMS3_at_msmail.bms.com (Dan Roberts) wrote:

>--
>Netters...After I have created a table and created the primary and foreign
>key constriants..how do I view them to make sure I did it correctly??

I have a set of scripts which reverse engineers a table definition, including constraints. It uses the ALL_TABLES, ALL_CONSTRAINTS, ALL_CONS_COLUMNS, ALL_INDEXES views in order to create DDL statements which (should) recreate the table, its keys, constraints, etc.

Please e-mail me if you would like a copy.

--
Doug Henderson, Glen Coulee Consulting, Calgary, Alberta

Received on Tue May 16 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: joel.cort_at_ctg.com: "Help Creating Oracle Server on AIX"
Previous message: Mahesh Vallampati: "Re: How do I view the key contraints on Oracle7??"
In reply to: Dan Roberts: "How do I view the key contraints on Oracle7??"
Next in thread: joel.cort_at_ctg.com: "Help Creating Oracle Server on AIX"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message