Sans titre

public text v1 · immutable

#249719

·published 2006-11-16 02:23 UTC

Create table T_Categories
(
	primary key ('Cat_No'),
	'Cat_No'	integer identity(1000,1) unique 		NOT NULL,
	'Cat_Nom'	VarChar(20) 							NOT NULL,
)

Create table T_Produits
(
	primary key ('Pro_No','Cat_No'),
	'Pro_No'	integer identity(1000,1)  unique		NOT NULL,
	'Pro_Nom'	VarChar(50) 							NOT NULL,
	'Pro_Qte'	int			 							NOT NULL,
	'Pro_Prix'	Real									NOT NULL,
	'Cat_No'	integer								NOT NULL, 
)