how to modify in a table sql server?

Question

1.00/5 (2 votes)

See more:

Dear Sir

I Tried many times when i try to modify in database in table field so it shows error not allowed to add any field like i forgot two field in my a customer table

Price and sale date then when i try to add again after any test entry so it shows always error

Posted 2-Aug-14 0:39am

irfanansari

Updated 2-Aug-14 0:45am

Nirav Prabtani

v2

Add a Solution

Comments

prasanna.raj 2-Aug-14 6:54am

give me the error msg.

irfanansari 2-Aug-14 6:58am

sir how can i give u it is can capture by keyboard in format of a image

2 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)

CPallini · Answer 1 · 2014-08-02T01:23:00

Solution 1

See the SQL ALTER TABLE statement at w3schools.com[^].

Posted 2-Aug-14 1:23am

CPallini

Comments

irfanansari 3-Aug-14 7:45am

but sir how can i add culum in center or after any particulate culum like
first name
last name
then i want to add after first name middle name

Magic Wonder · Answer 2 · 2014-08-03T20:10:00

Hi,

There is no issue if you will add columns in last, all you have to make changes in your select statement.

Anyway if you still want to do it, you can do it as mentioned below.

1. using SQL Server Management Studio

2. you can also check below steps
a. add column to your original table i.e. your_table
b. make use of Select (order of your columns) into table_test from your_table (optional) Order by anycol
c. drop your original table i.e. your_table
d. Rename your new table i.e. table_test as per your original table name.

Choice is yours.

Hope this will help you.

Cheers