Delete a Version (Master Data Services)
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.
Caution
|
|---|
|
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.
Note
You may have to wait a few minutes before the Web application reflects the change.
