delete-a-version-master-data-services.md

description	Delete a Version (Master Data Services)
title	Delete a Version
ms.custom
ms.date	03/01/2017
ms.prod	sql
ms.prod_service	mds
ms.reviewer
ms.technology	master-data-services
ms.topic	conceptual
helpviewer_keywords	versions [Master Data Services], deleting deleting versions [Master Data Services]
ms.assetid	2a4eeffe-8379-4744-ad44-c27d8c8ac9a8
author	CordeliaGrey
ms.author	jiwang6

Delete a Version (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI ]

In [!INCLUDEssMDSshort], delete a version when you are sure you no longer need the master data associated with the version. After you delete a version, you cannot retrieve the associated master data.

Warning

If a model has only one version and you delete it, the model becomes unusable.

Prerequisites

To perform this procedure:

• You must have permission to view the mdm.viw_SYSTEM_SCHEMA_VERSION view and to execute the mds.udpVersionDelete stored procedure in the [!INCLUDEssMDSshort] database. For more information, see Database Object Security (Master Data Services).

To delete a version

1. Open [!INCLUDEssManStudioFull] and connect to the [!INCLUDEssDE] instance for your [!INCLUDEssMDSshort] database.

2. Open the mdm.viw_SYSTEM_SCHEMA_VERSION view.

3. Find the version of the model you want to delete and copy the value in the ID field.

4. Create a new query.

5. Type the following text, replacing version_ID with the value you copied in step 2.

   EXEC [mdm].[udpVersionDelete] @Version_ID='version_ID'  
   

6. Run the query.

   [!NOTE]
   You may have to wait a few minutes before the Web application reflects the change.

See Also

Versions (Master Data Services)
Copy a Version (Master Data Services)