SQL Queries - Common SQL Queries - Queries on Source Code - How to remove source code from CAST databases

The purpose of this page is to provide queries to remove source code from CAST databases.  This is generally not a recommended operation and there are impacts to running these queries as source code will no longer be visible on the CAST dashboards to assist in violation understanding and remediation.  To add source code back into the databases, please see the documentation:

• For the local database:  CMS - Upload Source Code for viewing in CAST Dashboard
• For the central database: Using the GUI and CLI tools for Engineering Dashboar

 To remove source code from the local database, run this query on the local database:

UPDATE dss_code_sources SET    source_code = NULL;

 To remove source code from the central database, run this query on the central database:

UPDATE dss_source_texts SET    source_text = NULL;