| title | sp_helpmergearticlecolumn (Transact-SQL) | ||
|---|---|---|---|
| description | Returns the list of columns in the specified table or view article for a merge publication. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | replication | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!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
sp_helpmergearticlecolumn
[ @publication = ] N'publication'
, [ @article = ] N'article'
[ ; ]
The name of the publication. @publication is sysname, with no default.
The name of a table or view that is the article to retrieve information on. @article is sysname, with no default.
| 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. |
0 (success) or 1 (failure).
sp_helpmergearticlecolumn is used in merge replication.
Only members of the replmonitor fixed database role in the distribution database or the publication access list for the publication can execute sp_helpmergearticlecolumn.