How do I lock a column

How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?

Questions by nicoleyoungabney10

Showing Answers 1 - 2 of 2 Answers

binita007

  • Dec 21st, 2010
 

For this purpose, Views are there in SQL Server.

You can Create a view by leaving the column you need to restrict

User can edit all the fields in the view except the one you restrict .

Binita.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions