Simple Question - Value Lists in SQL

[Mike555]

I had asked this question previous in the SQL Programming forum.

What is the SQL's equivalent of MS Access's value list? Specifically, if I need to create a SQL table column that allows the user to select from a list of values, how is that done? In Access, when you build the table you can specify this, but I don't see this property when building SQL tables. Thanks.

--
Mike

 

[SQLSister]

To limit data entry to certain values, create a constraint. Read about them in BOL.

To select values from a list box on a form, create a look-up table that is then the source for the list box.

Questions about posting. See faq183-874

 

[Mike555]

Thank you, SqlSister

--
Mike