Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Phillip — — source: Informix-list mailing list archive (1991-1998)
try the sysconstraints table.
select * from sysconstraints will give you all the constraints, even the systemgenerated ones.
Lukasz Feldman wrote:
> Hello!
>
> Does anybody know a freeware or shareware software which can give me a list
> of constraints in all of the tables in informix database. I wonder about
> something like
> Oracle Enterprise Manager bu for Informix.
> My task is to find a broken referenced key. It is so much complicated to
> browse
> through the tables, and tables and tables in dbaccess.
>
> Luke.
>
> --
> Lukasz Feldman,
> Consultant
> Department of Network Planning & New Services
> ATM S.A.
> tel (+48 22) 5156406
> fax (+48 22) 5156146
> mobile (+48) 607 167 634
> e-mail: lukasz.feldman@atm.com.pl
--
Phillip Tien
Database Administrator
Whole Foods Market, Inc.
It's not gonna be an orgy...it's a toga party.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.