Displays all columns in the underlying table.
sp_helparticlecolumns publication, article
where
This stored procedure returns 1 for columns that are published and 0 for those that are not published. It is useful in checking a vertical partition.
This example displays the columns of the authors article in the authors_publication publication.
sp_helparticlecolumns authors_publication, authors
Execute permission defaults to the public group.
syscolumns, sysarticles, syspublications, syssubscriptions, sysservers
| sp_addarticle | sp_droparticle |
| sp_addpublication | sp_droppublication |
| sp_articlecolumn | sp_enumfullsubscribers |
| sp_changearticle | sp_helparticle |
| sp_changepublication | sp_helppublication |