How to modify database value

Question

1.00/5 (2 votes)

See more:

I have designing in my web page .my database table the id is allow null value i have set ok.i had store the value in table.but i want Id values not allow null value .how to change in my table

Posted 22-May-11 23:27pm

kannan 2

Add a Solution

Comments

Prerak Patel 23-May-11 5:47am

Try to rephrase you question. Not allowing null for ID field is not a big task I guess.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-05-22T23:56:00

Solution 3

In Enterprise manager, it is very easy, just remove check mark from "Allow Nulls".

Try following statements one by one,

SQL

UPDATE [Table] SET [Column]=0 WHERE [Column] IS NULL
ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL

Posted 22-May-11 23:56pm

Prerak Patel

Updated 22-May-11 23:57pm

v2

**R. Giskard Reventlov** · Answer 2 · 2011-05-22T23:50:00

Solution 1

Right click on the table and select 'Modify'. Un-check the 'Allow Nulls' checkbox on the appropriate column and save. The table should either be empty or ensure that the column does not contain any null values before you proceed.

Posted 22-May-11 23:50pm

R. Giskard Reventlov

NuttingCDEF · Answer 3 · 2011-05-22T23:53:00

Assuming you are using SQL Server, do you have SQL Server Management Studio Express installed? If not install it. Then use it to connect to your server / database and modify your table - untick the Allow Nulls box for your ID field and save. If you are using Linq, you then need to remove / re-add the table to your data context so that your code picks up the change.