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 Sub SetColumnDestinationDataType ( _
    columnName As String, _
    dataType As String, _
    precision As Long, _
    scale As Integer, _
    length As Long _
)
‘사용 방법
Dim instance As TransArticle 
Dim columnName As String 
Dim dataType As String 
Dim precision As Long 
Dim scale As Integer 
Dim length As Long

instance.SetColumnDestinationDataType(columnName, _
    dataType, precision, scale, length)
public void SetColumnDestinationDataType(
    string columnName,
    string dataType,
    long precision,
    int scale,
    long length
)
public:
void SetColumnDestinationDataType(
    String^ columnName, 
    String^ dataType, 
    long long precision, 
    int scale, 
    long long length
)
member SetColumnDestinationDataType : 
        columnName:string * 
        dataType:string * 
        precision:int64 * 
        scale:int * 
        length:int64 -> unit
public function SetColumnDestinationDataType(
    columnName : String, 
    dataType : String, 
    precision : long, 
    scale : int, 
    length : long
)

매개 변수

  • 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.

참고 항목

참조

TransArticle 클래스

Microsoft.SqlServer.Replication 네임스페이스

관련 자료

Oracle 게시자에 대한 데이터 형식 매핑