sp_changearticle (version 6.5)

Changes an article's properties.

For additional syntax information for sp_changearticle, see the Microsoft SQL Server Transact-SQL Reference.

Syntax

sp_changearticle publication, article [, property, value]

where

property

Specifies an article property to change. Can be:

status

value

Specifies the article value. Can be used with:

include column names

Allows column names in the replicated INSERT statement.

no column names

Allows no column names in the replicated INSERT statement.

owner qualified

Allows owner-qualified table names.

not owner qualified

Allows non-owner-qualified table names.