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
Thanks.
multisave.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No, it shouldn't cause any defects.
ASKER
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.
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.
ASKER
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"
"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"
ASKER
Thanks.
ASKER
I already use the table designer and added cloumns and clicked OK to continue saving on multiple tables. Will it cause any defects?