CREATE TABLE S_COM.T_CLIENT_CLI
(CLI_ID      INTEGER NOT NULL PRIMARY KEY,
 CLI_NOM     CHAR(32),
 CDE_ID      INTEGER NOT NULL,
 CONSTRAINT  FK_CLI_CDE FOREIGN KEY (CDE_ID) 
             REFERENCES S_COM.T_COMMANDE (CDE_ID));

CREATE TABLE S_COM.T_COMMANDE_CDE
(CDE_ID      INTEGER NOT NULL PRIMARY KEY,
 CDE_DATE    DATE,
 CLI_ID      INTEGER NOT NULL,
 CONSTRAINT  FK_CDE_CLI FOREIGN KEY (CLI_ID)
             REFERENCES S_COM.T_CLIENT (CLIK_ID)
             DEFERRABLE);

SET CONSTRAINTS FK_CDE_CLI DEFERRED;

BEGIN TRANSACTION ;

INSERT INTO S_COM.T_CLIENT_CLI VALUES (101, 'DUPONT');

INSERT INTO S_COM.T_COMMANDE_CDE VALUE (4589, '2005-09-01', 101);

UPDATE S_COM.T_CLIENT_CLI SET CDE_ID = 4589 WHERE CLI_ID = 101;

COMMIT ;

