Delete a Version (Master Data Services)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
In Master Data Services, 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.
If a model has only one version and you delete it, the model becomes unusable.
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 Master Data Services database. For more information, see Database Object Security (Master Data Services).
To delete a version
Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
Open the mdm.viw_SYSTEM_SCHEMA_VERSION view.
Find the version of the model you want to delete and copy the value in the ID field.
Create a new query.
Type the following text, replacing version_ID with the value you copied in step 2.
EXEC [mdm].[udpVersionDelete] @Version_ID='version_ID'
Run the query.
You may have to wait a few minutes before the Web application reflects the change.