CHECK Table Level|([EndDate]>=[StartDate])
DEFAULT on column DiscountPct|((0.0))
DEFAULT on column MinQty|((0))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
PRIMARY KEY (clustered)|SpecialOfferID