Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

TransArticle.ScriptChangeColumnDestinationDataType Method

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

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public string ScriptChangeColumnDestinationDataType(
	string columnName,
	string dataType,
	long precision,
	int scale,
	long length,
	ScriptOptions scriptOption
)

Parameters

columnName
Type: String
A String value that specifies the name of the column for which the destination data type is changed.
dataType
Type: String
A String value that specifies the data type to which the column is changed.
precision
Type: 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
Type: 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
Type: 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
Type: Microsoft.SqlServer.Replication.ScriptOptions
A ScriptOptions object value that specifies the scripting options.

Return Value

Type: String
A String value that contains a Transact-SQL script.

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.

Community Additions

Show:
© 2015 Microsoft