TransArticle.ScriptChangeColumnDestinationDataType Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Replication

Assembly:: Microsoft.SqlServer.Rmo.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns a Transact-SQL script used to change the column data type mapping for a non-SQL Server Publisher.

public:
 System::String ^ ScriptChangeColumnDestinationDataType(System::String ^ columnName, System::String ^ dataType, long precision, int scale, long length, Microsoft::SqlServer::Replication::ScriptOptions scriptOption);

public string ScriptChangeColumnDestinationDataType (string columnName, string dataType, long precision, int scale, long length, Microsoft.SqlServer.Replication.ScriptOptions scriptOption);

member this.ScriptChangeColumnDestinationDataType : string * string * int64 * int * int64 * Microsoft.SqlServer.Replication.ScriptOptions -> string

Public Function ScriptChangeColumnDestinationDataType (columnName As String, dataType As String, precision As Long, scale As Integer, length As Long, scriptOption As ScriptOptions) As String

Parameters

columnName: String

A String value that specifies the name of the column for which the destination data type is changed.

dataType: String

A String value that specifies the data type to which the column is changed.

precision: Int64

An Int32 value that specifies the precision of the data type. Set this parameter to -1 if it does not apply to the specified data type.

scale: Int32

An Int32 value that specifies the scale of the data type. Set this parameter to -1 if it does not apply to the specified data type.

length: Int64

An Int32 value that specifies the length of the data type. Set this parameter to -1 if it does not apply to the specified data type.

scriptOption: ScriptOptions

A ScriptOptions object value that specifies the scripting options.

Returns

String

A String value that contains a Transact-SQL script.

Remarks

The ScriptChangeColumnDestinationDataType method is only supported for a non-SQL Server Publisher.

The scriptOption parameter specifies what to include in the script. Use Creation to return a creation script. Use Deletion to return a deletion script. Use IncludePublications to include all publications. Use IncludePullSubscriptions to include all pull subscriptions.

Applies to

Share via