---
title: "Deleting License Transactions and Definitions"
canonical: "https://ai-docs.certero.com/space/CUP/118656211/Deleting%20License%20Transactions%20and%20Definitions"
format: markdown
---
# <span style="color: #2077ac">Deleting License Transactions and Definitions </span>

You may at some point need to truncate licensing data and license definitions. The SQL script below will truncate the data in the relevant tables.  N.B. Comment out the relevant lines in the script.  If you are unsure how to use this script please contact Certero support on [helpdesk@certero.com ](mailto:helpdesk@certero.com)

BEGIN TRAN 

-- Delete Microsoft Licensing Data 

DELETE FROM LicensingMicrosoft.MicrosoftTransaction 

DELETE FROM LicensingMicrosoft.MicrosoftCategoryItemObject 

DELETE FROM LicensingMicrosoft.MicrosoftEntitlement 

DELETE FROM LicensingMicrosoft.MicrosoftLicenceMetric 

-- Delete Adobe Licensing Data 

DELETE FROM LicensingAdobe.AdobeTransaction 

DELETE FROM LicensingAdobe.AdobeCategoryItemObject 

DELETE FROM LicensingAdobe.AdobeEntitlement 

DELETE FROM LicensingAdobe.AdobeLicenceMetric 

-- Delete Generic Licensing Data 

DELETE FROM LicensingCommon.LicenceTransaction 

DELETE FROM LicensingCommon.LicenceCategoryItemObject 

DELETE FROM LicensingCommon.LicenceAgreement 

DELETE FROM LicensingCommon.LicenceSupplier 

COMMIT