Setting table field constraints

  • I would like to define a new column in a table give it a default value of 0. Easy enough. But I only want the column to store either 0 or 100 and nothing else. Should I invoke an inert/update trigger or define a UDEF? How would this be done. I have not had luck finding examples of this or in the help files. I would appreciate an example or if someone can point me to some references that explain how to set this up? Thanks for any help.

  • Have you tried to use "CHECK constraint"?

  • Yes that is what I will do just create the constraint in the design view. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply