如要将价格(price)限制为100及以下,应使用如下子句中的哪一个
A.CONSTRAINT inventory_price_ck CHECK (price<100.00)
B.CONSTRAINT CHECK inventory_price_ck (price<100.00)
C.CONSTRAINT inventory_price_ck CHECK (price<=100.00)
D.CONSTRAINT CHECK inventory_price_ck(price<=100.00)
E.CONSTRAINT inventory_price_ck CHECK(price IN (100.00))