-- 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