Post reply

column in table

  • April 17, 2003 at 6:01 pm

    #158874

    I have a table with a column that is to be within a few possiblities.

    eg.

    table:

    id int not null,

    car_make varchar(50)

    now the car_make can be either honda, toyota, GM, acura

    How do I create a constraint like that using EM?

  • April 18, 2003 at 5:15 am

    #454651

    Either setup another table with the possible values and create a relationship (good for a lot of items). Or in EM in the design view of the table right click and pick Constraints then add

    column_name IN ('your','list')

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

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