Re: to browse constraints in informix

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.