sp_MSrepl_dropdatatypemappings (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_MSrepl_dropdatatypemappings()

MetaData:

   
--   
--  Name:  
--         sp_MSrepl_dropdatatypemappings  
--   
--  Description:  
--         Drops data type mapping tables  
--   
--  Returns:  
--         0 if successful  
--         1 if failed  
--   
--  Security:  
--         Public  
--  Requires Certificate signature for catalog access  
--   
--  Notes:  
--         Expected to be called internally only via MSDB install script  
--           
--   
  
create procedure sys.sp_MSrepl_dropdatatypemappings  
as  
begin  
    DECLARE @cmd nvarchar(4000)  
      
    --   
    --  Security Check: require sysadmin  
    --   
    IF (ISNULL(IS_SRVROLEMEMBER('sysadmin'),0) = 0)  
    BEGIN  
        RAISERROR(21089,16,-1)   
        RETURN (1)  
    END  
  
    --  MSdatatype_mappings view  
    IF OBJECT_ID(N'dbo.MSdatatype_mappings', 'V') IS NOT NULL  
    BEGIN  
        PRINT 'Dropping view MSdatatype_mappings...'  
          
        SELECT @cmd = 'DROP VIEW dbo.MSdatatype_mappings'  
        EXEC(@cmd)  
    END  
      
    --  sysdatatypemappings view  
    IF OBJECT_ID(N'dbo.sysdatatypemappings', 'V') IS NOT NULL  
    BEGIN  
        PRINT 'Dropping view sysdatatypemappings...'  
          
        SELECT @cmd = 'DROP VIEW dbo.sysdatatypemappings'  
        EXEC(@cmd)  
    END  
  
    --  MSdbms_datatype_mapping  
    IF OBJECT_ID(N'dbo.MSdbms_datatype_mapping', 'U') IS NOT NULL  
    BEGIN  
        PRINT 'Dropping table MSdbms_datatype_mapping...'  
  
        ALTER TABLE MSdbms_map  
        DROP CONSTRAINT fk_MSdbms_map_default_datatype_mapping_id  
  
        DROP TABLE dbo.MSdbms_datatype_mapping  
    END  
  
    --  MSdbms_map  
    IF OBJECT_ID(N'dbo.MSdbms_map', 'U') IS NOT NULL  
    BEGIN  
        PRINT 'Dropping table MSdbms_map...'  
        DROP TABLE dbo.MSdbms_map  
    END  
  
    --  MSdbms_datatype  
    IF OBJECT_ID(N'dbo.MSdbms_datatype', 'U') IS NOT NULL  
    BEGIN  
        PRINT 'Dropping table MSdbms_datatype...'  
        DROP TABLE dbo.MSdbms_datatype  
    END  
  
    --  MSdbms  
    IF OBJECT_ID(N'dbo.MSdbms', 'U') IS NOT NULL  
    BEGIN  
        PRINT 'Dropping table MSdbms...'  
        DROP TABLE dbo.MSdbms  
    END  
END