Transact-SQL Reference
sp_helpmergearticlecolumn
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.
Syntax
sp_helpmergearticlecolumn [ @publication = ] 'publication' ]
, [ @article = ] 'article' ]
Arguments
[@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.
Result Sets
| Column name | Data type | Description |
|---|---|---|
| column_id | sysname | Is the identification number of 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. |
Remarks
sp_helpmergearticlecolumn is used in merge replication.
Permissions
Execute permissions default to the public role.