sp-helpmergearticlecolumn-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sp_helpmergearticlecolumn (Transact-SQL)	Returns the list of columns in the specified table or view article for a merge publication.	markingmyname	maghan	randolphwest	11/23/2023	sql	replication	reference	sp_helpmergearticlecolumn sp_helpmergearticlecolumn_TSQL	sp_helpmergearticlecolumn	TSQL

sp_helpmergearticlecolumn (Transact-SQL)

[!INCLUDE SQL Server]

Returns the list of columns in the specified table or view article for a merge publication. Because stored procedures don't have columns, this stored procedure returns an error if a stored procedure is specified as the article. This stored procedure is executed at the Publisher on the publication database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_helpmergearticlecolumn
    [ @publication = ] N'publication'
    , [ @article = ] N'article'
[ ; ]

Arguments

[ @publication = ] N'publication'

The name of the publication. @publication is sysname, with no default.

[ @article = ] N'article'

The name of a table or view that is the article to retrieve information on. @article is sysname, with no default.

Result set

Column name	Data type	Description
column_id	sysname	Identifies the column.
column_name	sysname	The name of the column for a table or view.
published	bit	Specifies if the column name is published. 1 specifies that the column is being published. 0 specifies that it isn't published.

Return code values

0 (success) or 1 (failure).

Remarks

sp_helpmergearticlecolumn is used in merge replication.

Permissions

Only members of the replmonitor fixed database role in the distribution database or the publication access list for the publication can execute sp_helpmergearticlecolumn.

Related content

• System stored procedures (Transact-SQL)