TransArticle.SetColumnDestinationDataType Method

Definition

Sets the column data type mapping for a non-SQL Server Publisher.

public:
 void SetColumnDestinationDataType(System::String ^ columnName, System::String ^ dataType, long precision, int scale, long length);
public void SetColumnDestinationDataType (string columnName, string dataType, long precision, int scale, long length);
member this.SetColumnDestinationDataType : string * string * int64 * int * int64 -> unit
Public Sub SetColumnDestinationDataType (columnName As String, dataType As String, precision As Long, scale As Integer, length As Long)

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.

Remarks

The SetColumnDestinationDataType method is only supported for non-SQL Server Publishers.

The SetColumnDestinationDataType method can only be called by members of the sysadmin fixed server role at the Distributor or by members of the db_owner fixed database role on the database.

Calling SetColumnDestinationDataType is equivalent to executing sp_changearticlecolumndatatype.

Applies to