March 19, 2010 at 4:17 pm
Hi I was wondering if it is possible to desginate a dropdownlist for a column
When a user goes into the database and opens a table to edit/add values, can you make a column be a dropdownlist, so that only a specific set of values are allowed to be entered?
March 19, 2010 at 4:46 pm
jlizzi (3/19/2010)
Hi I was wondering if it is possible to desginate a dropdownlist for a columnWhen a user goes into the database and opens a table to edit/add values, can you make a column be a dropdownlist, so that only a specific set of values are allowed to be entered?
You can do that at the application level. However, users should not be editing data directly in the database from SSMS such as explained here.
Have them access the database through the app tier.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply