sp_MSremove_mergereplcommand (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_MSremove_mergereplcommand(nvarchar @publication
, nvarchar @article
, int @schematype)

MetaData:

   
--  Remove an article command of a specific tyep from dbo.sysmergeschemachange- Used by snapshot  --   
create procedure sys.sp_MSremove_mergereplcommand (  
    @publication        sysname,  
    @article            sysname,  
    @schematype         int  
    ) AS  
    set nocount on  
    declare @pubid              uniqueidentifier  
    declare @artid              uniqueidentifier  
    declare @retcode            int      
  
    --  added for client requested snapshot to work.  
    --  when a non-dbo user comes in only do all checking and subsequent removing if the command exists in the first place.  
    exec @retcode=sys.sp_MSrepl_PAL_rolecheck @publication = @publication  
    if @retcode<>0 or @@ERROR<>0 return (1)  
  
    select @pubid = pubid FROM dbo.sysmergepublications WHERE name = @publication and UPPER(publisher)=UPPER(publishingservername()) and publisher_db=db_name()  
    select @artid = artid FROM dbo.sysmergeextendedarticlesview WHERE name = @article and pubid=@pubid  
    if not exists(select * from dbo.sysmergeschemachange where pubid = @pubid and artid = @artid and schematype = @schematype)  
        return 0  
  
    exec @retcode=sys.sp_MSreplcheck_publish  
    if @retcode<>0 or @@ERROR<>0 return (1)  
      
    if @publication IS NULL  
    begin  
        raiserror (14003, 16, -1)  
        return (1)  
    end  
      
    if @article IS NULL  
    begin  
        raiserror (20045, 16, -1)  
        return (1)  
    end  
  
    delete dbo.sysmergeschemachange where pubid = @pubid  
                                  and artid = @artid  
                             and schematype = @schematype