Returns all columns in the underlying table.
sp_helparticlecolumns [@publication =] 'publication', [@article =] 'article'
0 (columns that are not published) or 1 (columns that are published)
| 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 1 = Yes |
sp_helparticlecolumns is used in snapshot and transactional replication.
sp_helparticlecolumns is useful in checking a vertical partition.
Execute permissions default to the public role.
| sp_addarticle | sp_droparticle |
| sp_addpublication | sp_droppublication |
| sp_articlecolumn | sp_enumfullsubscribers |
| sp_changearticle | sp_helppublication |
| sp_changepublication | System Stored Procedures |