The table(view) which you need to look at is All_constraints
This will cover primary key not null etc.
You need to Query this table and reproduce the scripts.
Tom
TDavison <INVALID_at_PCOM.NET> wrote in message
news:38e00667$1_at_news.pcom.net...
> I'm new to Oracle programming and I am trying to write a PL/SQL script
that
> when run will query the data dictionary tables and will re-create the
script
> that created and applied the constraints to the table in the first place.
> Does anyone have any sample code of how they did such a thing?
>
>
Received on Tue Mar 28 2000 - 00:42:51 CST
