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
LVL 1
minglelinchAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
 
minglelinchAuthor Commented:
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?
0
 
Christopher KileCommented:
No, it shouldn't cause any defects.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
minglelinchAuthor Commented:
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.
0
 
Christopher KileCommented:
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.
0
 
minglelinchAuthor Commented:
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"
0
 
minglelinchAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.