通过

TransArticle.ScriptChangeColumnDestinationDataType Method

  • 项目

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 (in microsoft.sqlserver.rmo.dll)

语法

声明
Public Function ScriptChangeColumnDestinationDataType ( _
    columnName As String, _
    dataType As String, _
    precision As Long, _
    scale As Integer, _
    length As Long, _
    scriptOption As ScriptOptions _
) As String

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

public:
String^ ScriptChangeColumnDestinationDataType (
    String^ columnName, 
    String^ dataType, 
    long long precision, 
    int scale, 
    long long length, 
    ScriptOptions scriptOption
)

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

public function ScriptChangeColumnDestinationDataType (
    columnName : String, 
    dataType : String, 
    precision : long, 
    scale : int, 
    length : long, 
    scriptOption : ScriptOptions
) : String

参数

  • columnName
    A String value that specifies the name of the column for which the destination data type is changed.
  • dataType
    A String value that specifies the data type to which the column is changed.
  • precision
    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
    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
    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
    A ScriptOptions object value that specifies the scripting options.

返回值

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.

The ScriptChangeColumnDestinationDataType method is only available when working with instances of SQL Server 2005 or later.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

TransArticle Class
TransArticle Members
Microsoft.SqlServer.Replication Namespace

其他资源

Oracle 发布服务器的数据类型映射