Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
spradhan
Starting Member
3 Posts |
Posted - 2010-03-19 : 12:49:44
|
I want to predefined the value in the one of column of tableso user can only choose one of this predefined value.For example: like in state field we can chosse only chosse state in list of field. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-19 : 13:02:46
|
seems like what you're asking for is a check constraint on state field to define a set of allowable values------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|