Hi everybody,

If my field can be either Y or N, how can I specify it? Or if the field can be only one of 3 predefined values?

Also, is it right to create one index with three columns? One of the fields is FK, two others just regular fields, but may be useful in joins or where clause...

I've generated relationship:

ALTER TABLE dbo.CartDetail ADD CONSTRAINT
	FK_CartDetail_CartContent FOREIGN KEY
	(
	CartContentID
	) REFERENCES dbo.CartContent
	(
	CartContentID
	) ON UPDATE CASCADE
	 ON DELETE CASCADE
	
GO

It is the same, as triggers? Or should I do something different?



Thanks in advance.