Delete a Version (Master Data Services)
Applies To: SQL Server 2016
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.
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).
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.