CHECK Table Level|([CreditRating]>=(1) AND [CreditRating]<=(5))
DEFAULT on column ActiveFlag|((1))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column PreferredVendorStatus|((1))
PRIMARY KEY (clustered)|VendorID