Re: primary key lost

Hi Dirk, Thank you for your tips,I have found why the primary key's lost already. someone had altered the table's primary key column's default value,and did'nt know that is a primary key. "Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message news:<1109941833.b7e88f1e4e9afacc8e3aba1c423c20b0@teranews>... > Does this table get dropped & recreated ? Have you looked at the table > creation date ? > > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of roger huang > Sent: 04 March 2005 10:47 AM > To: informix-list@iiug.org > Subject: primary key lost > > Hi all, > Any one can help me? > my box is : > redhat 7.3, ids9.40UC5 > I have a table with primary key, but it often disappeared like ghosts. > I had to recreate it again. Is anyone happened this before? > Or somebody can give me some tips that I can find out how it did that. > Any information will be appreciated. Thank you in advance. > > sending to informix-list