CREATE TABLE S_COMMERCIAL.T_CLIENT_CLI
(CLI_NOM        VARCHAR(32),
 CLI_CREATION   DATE DEFAULT CURRENT_DATE,
 CLI_REMISE     D_POURCENT CONSTRAINT DK_REMISE DEFAULT 10.0);


/*

--> syntaxe pour SQL Server 

CREATE TABLE S_COMMERCIAL.T_CLIENT_CLI
(CLI_NOM        VARCHAR(32),
 CLI_CREATION   DATE DEFAULT CURRENT_TIMESTAMP,
 CLI_REMISE     D_POURCENT CONSTRAINT DK_REMISE DEFAULT 10.0);

*/
