TransArticle.ScriptChangeColumnDestinationDataType 메서드

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

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

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

매개 변수

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.
scriptOption
유형: Microsoft.SqlServer.Replication.ScriptOptions
A ScriptOptions object value that specifies the scripting options.

반환 값

유형: System.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.

커뮤니티 추가 항목

추가
표시: