Link to home
Start Free TrialLog in
Avatar of minglelinch
minglelinch

asked on

table changes saving issue

I opened a table design view in SQL srever 2005, I added a column to the table, and then clicked the X button, and been promted by a dialog box for saving the changes, and I clciked Yes. Then a confirm dialog asked me if I save on other three tables too. I only added a column in one table, why does it ask me if I save on four tables? Is there any internal setting stuff causing it? Please the attached file.

Thanks.
multisave.JPG
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of minglelinch
minglelinch

ASKER

Ok. Thank you.

I already use the table designer and added cloumns and clicked OK to continue saving on multiple tables. Will it cause any defects?
No, it shouldn't cause any defects.
I've requested that this question be closed as follows:

Accepted answer: 0 points for minglelinch's comment #a38374007

for the following reason:

Thanks for the solution.
minglelinch, you can't assign the solution to yourself if you got the solution from aneeshattingal, which your closing comment indicates you did.  Please cancel your deletion and give him the points.
Sorry, my mistake. I should choose the first answer as the solution. Please correct it for me.

"Could be due to some foreign key references, you should use the ALTER table statement instrad of the table designer, the table designer will lock the table and has to  perform few other tasks behind the scenes to add a column"
Thanks.