sp_dropprimaryart

Description

Deletes an existing primary article (or articles) from a specified publication.

Syntax

sp_dropprimaryart pub_name [, pri_art]

Parameters

pub_name

is the name of the publication to which the existing article belongs.

pri_art

is the name of a primary article. Primary article names can be specified in the form owner.name.

Examples

Example 1

sp_dropprimaryart pubdoc, table1

Deletes the primary article table1 in the publication pubdoc.

Usage

See also

sp_addprimaryart, sp_droppub, sp_dropreplicateart, sp_helpprimaryart, sp_helpprimaryconn, sp_helppub