Re: Create table error

Posted in 2000

Obnoxio The Clown — Wed, 12 Jan 2000 09:05:26 GMT — source: Informix-list mailing list archive (1991-1998)

From: John Harman <harmanj@agric.nsw.gov.au> > > When running an sql to create a table, I'm getting a 'constraint >already exists' error, with an id like 'n359_1147'. Can anyone give me a >clue what causes this ?? Um. Errr. You already have a constraint called n359_1147 on another table. Try naming explicitly (to something different) all the contraints on your new table. (The one that's failing is a NOT NULL, I guess) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com