Transact-SQL Reference
sp_helparticlecolumns
Returns all columns in the underlying table. This stored procedure is executed at the Publisher on the publication database.
Syntax
sp_helparticlecolumns [ @publication = ] 'publication'
, [ @article = ] 'article'
Arguments
[@publication = ] 'publication'
Is the name of the publication that contains the article. publication is sysname, with no default.
[@article = ] 'article'
Is the name of the article that has its columns returned. article is sysname, with no default.
Return Code Values
0 (columns that are not published) or 1 (columns that are published)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| column id | int | Object ID of the table to which this column belongs. |
| column | sysname | Name of the column. |
| published | bit | Whether column is published:
0 = No |
Remarks
sp_helparticlecolumns is used in snapshot and transactional replication.
sp_helparticlecolumns is useful in checking a vertical partition.
Permissions
Execute permissions default to the public role.