sp_helparticlecolumns

Transact-SQL Reference

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
1 = Yes


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.

See Also

sp_addarticle

sp_addpublication

sp_articlecolumn

sp_changearticle

sp_changepublication

sp_droparticle

sp_droppublication

sp_enumfullsubscribers

sp_helppublication

System Stored Procedures