SQL Server Mangement Studio Alter Script (2005)

Question

Is it possible to generate an ALTER sql script from the changes you are making in Server Studio. This is possible in different tools for mysql, basically you get a log of executed statements. Is this possible here, or how do you know what a modification (ALTER) script is?

Thank.

- MB

Answer 1

You can automatically generate change scripts in SSMS. Take a look at this article, I believe that this may be what you are looking for. http://www.mssqltips.com/tip.asp?tip=1723

from article

, T-SQL, SQL Server. SQL Server Management Studio " Script...", script / , SQL Server Management Studio (SSMS)? , SSMS, .

Answer 2

( Design), Table Designer Generate Change Script.

, , Script, .

Answer 3

SQL Server 2005, SQL Server Management Studio 2008 .

( "" ), SSMS ALTER , " ":