TransArticle.SetColumnDestinationDataType 메서드

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

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

public void SetColumnDestinationDataType(
	string columnName,
	string dataType,
	long precision,
	int scale,
	long length
)

매개 변수

columnName
유형: System.String
A String value that specifies the name of the column for which the destination data type is changed.
dataType
유형: System.String
A String value that specifies the data type to which the column is changed.
precision
유형: System.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
유형: System.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
유형: System.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.

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.

커뮤니티 추가 항목

추가
표시: