How to Modify Publications and Articles (Transact-SQL)
To view snapshot or transactional publication properties
- Execute sp_helppublication to display information about a publication.
To view merge publication properties
- Execute sp_helpmergepublication to display information about a publication.
To modify publication properties
- Execute sp_changepublication to modify the properties of a publication.
To modify merge publication properties
- Execute sp_changemergepublication to modify the properties of a publication.
To view article properties for a snapshot or transactional publication
- Execute sp_helparticle to display information about an article.
- Execute sp_helparticlecolumns to display all columns in the table underlying an article.
To view merge article properties
- Execute sp_helpmergearticle to display information about a merge article.
- Execute sp_helpmergefilter to display information about merge filters.
To modify article properties for a snapshot or transactional publication
- Execute sp_changearticle to change the properties of an article.
To modify merge article properties
- Execute sp_changemergearticle to change the properties of an article.
- Execute sp_changemergefilter to change the properties of a filter.