Udostępnij za pośrednictwem

sp_changearticlecolumndatatype (Transact-SQL)

  • Artykuł

Changes the article column data type mapping for an Oracle publication. This stored procedure is executed at the Distributor on any database.

[!UWAGA]

The data type mappings between supported Publisher types are provided by default. Use sp_changearticlecolumndatatype only when overriding these default settings.

Ikona łącza do tematu Transact-SQL Syntax Conventions

Składnia

sp_changearticlecolumndatatype [ @publication= ] 'publication'
    [ @article = ] 'article' 
    [ @column = ] 'column'
    [ , [ @type = ] 'type' ]
    [ , [ @length = ] length ]
    [ , [ @precision = ] precision ]
    [ , [ @scale = ] scale ]
    [ , [ @publisher = ] 'publisher'

Arguments

  • [ @publication= ] 'publication'
    Is the name of the Oracle publication. publication is sysname, with no default.

  • [ @article = ] 'article'
    Is the name of the article. article is sysname, with no default.

  • [ @column= ] 'column'
    Is the name of the column for which to change the data type mapping. column is sysname, with no default.

  • [ @type = ] 'type'
    Is the name of the Microsoft SQL Server data type in the destination column. type is sysname, with a default of NULL.

  • [ @length = ] length
    Is the length of the SQL Server data type in the destination column. length is bigint, with a default of NULL.

  • [ @precision= ] precision
    Is the precision of the SQL Server data type in the destination column. precision is bigint, with a default of NULL.

  • [ @publisher= ] 'publisher'
    Specifies a non-SQL Server publisher. publisher is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Uwagi

Sp_changearticlecolumndatatype is used to override the default data type mappings between supported Publisher types (Oracle and SQL Server). To view these default data type mappings, execute sp_getdefaultdatatypemapping.

sp_changearticlecolumndatatype is only supported for Oracle Publishers. Executing this stored procedure against a SQL Server publication results in an error.

sp_changearticlecolumndatatype must be executed for each article column mapping that must be changed.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_changearticlecolumndatatype.

Zobacz także

Odwołanie

Replication Stored Procedures (Transact-SQL)

Koncepcje

Change Publication and Article Properties

Data Type Mapping for Oracle Publishers