Returns the list of columns in the specified table or view article for a merge publication. Because stored procedures do not 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.
Transact-SQL Syntax Conventions
sp_helpmergearticlecolumn [ @publication = ] 'publication' ]
, [ @article= ] 'article' ]
- [ @publication=] 'publication'
-
Is the name of the publication. publication is sysname, with no default.
- [ @article=] 'article'
-
Is the name of a table or view that is the article to retrieve information on. article is sysname, with no default.
0 (success) or 1 (failure)
|
Column name
|
Data type
|
Description
|
|---|
|
column_id
|
sysname
|
Identifies the column.
|
|
column_name
|
sysname
|
Is 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 is not published.
|
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.
.png)
