Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE voiture(
- numImatriculation VARCHAR(15) CONSTRAINT ob_mat NOT NULL,
- marque VARCHAR(50) CONSTRAINT un_tel NOT NULL,
- DateMisEnCirculation DATETIME ,
- Prix REAL ,
- nbrchevaux INT ,
- kilometrage INT
- );
- ALTER TABLE voiture ADD CONSTRAINT sup_date CHECK(DateMisEnCirculation<getdate());
- ALTER TABLE voiture ADD CONSTRAINT check_prix CHECK(Prix BETWEEN 60000 AND 260000 );
- ALTER TABLE voiture ADD CONSTRAINT check_cheveaux CHECK(nbrchevaux BETWEEN 5 AND 15 );
- ALTER TABLE voiture ADD CONSTRAINT check_kilo CHECK(kilometrage >100 );
- ALTER TABLE voiture ADD CONSTRAINT check_marque CHECK(marque IN ('toyota','Renault','KIA'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement