How to create ALTER scripts instead of CREATE scripts using SMO (Server Management Object)

Question

I am using the Microsoft.SqlServer.Management.Smo classes to script out SQL scripts for stored procedures, tables, views etc. I am doing this for putting them in source control.

Instead of the CREATE scripts for stored procedures, how can I get ALTER scripts for them? Is there an setting / option in the ScriptingOptions' properties?

Answer 1

1. Use the normal scriptingoptions and tools for SMO c#

2. then simply use.

   foreach (string line in script)
               {
                   string l = line.Replace("CREATE FUNCTION", "ALTER FUNCTION");
               }
   

3. Ta Da. :).

Answer 2

The StoredProcedure class has a method that creates ALTER statements.

https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.storedprocedure.scriptheader(v=sql.120).aspx

Usage

var sprocHeader = sproc.ScriptHeader(forAlter: true);
var sprocBody = sproc.TextBody;