Share via


TransArticle.ScriptChangeColumnDestinationDataType Method

Definition

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

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