RE: Sorry, i'm French

thats ok mate, nobodys perfect...but you can ask for help here anyways... use ALTER TABLE statement with the ADD CONSTRAINT keywords..can use DROP CONSTRAINT as well... Example: ALTER TABLE tablename ADD CONSTRAINT UNIQUE (lname, fname) CONSTRAINT constraint_name ALTER TABLE tablename DROP CONTRAINT constraint_nameJames MCS Limited Hamilton Bermuda -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Ludovic Sent: Wednesday, May 03, 2000 7:00 AM To: informix-list@iiug.org Subject: Sorry, i'm French For Informix[SE] I want to know how to create or modify an Constraints Keys with Code ( Or with DBACCESS) or in french QQ'un aurait-il un bout de code pour Cr'er ou modifier des clefs de containte ou des explications pour DBACCESS -- Thank's Ludovic -------------------------> lbutet@yahoo.fr -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Ludovic Sent: Wednesday, May 03, 2000 7:00 AM To: informix-list@iiug.org Subject: Sorry, i'm French For Informix[SE] I want to know how to create or modify an Constraints Keys with Code ( Or with DBACCESS) or in french QQ'un aurait-il un bout de code pour Cr'er ou modifier des clefs de containte ou des explications pour DBACCESS -- Thank's Ludovic -------------------------> lbutet@yahoo.fr