Create table error
Posted in 2000
Topics: General Discussion
John Harman — — source: Informix-list mailing list archive (1991-1998)
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 ?? John
↪ replying to John Harman
Dirk Niemeier — — source: Informix-list mailing list archive (1991-1998)
Hi John,
I think the problems are the column constraints like NOT NULL.
You impoerted the DB with original constraint names from an old dbexport !?
Look into your import-script. You have to change the script before import
manually or use
a utility from Art Kagel.
HTH
Dirk
John Harman schrieb:
> 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 ??
>
> John