1. Download the SQL Script
   Download the script that removes all BDNA and BDNA_PUBLISH database objects from the following secure link:
   Download SQL Cleanup Script
2. Review the Script
   Before running the script, review the SQL statements to understand which objects will be dropped. The script includes commands to:
   • Drop all tables
   • Drop all views
   • Drop all stored procedures
     in both the BDNA and BDNA_PUBLISH schemas.
3. Backup Your Data
   Ensure you have recent database backups before proceeding.
4. Run the Script
   Execute the script using SQL Server Management Studio (SSMS) or your preferred SQL client:
   • Connect to the server hosting the BDNA and BDNA_PUBLISH databases.
   • Open the downloaded .sql file.
   • Execute the script against each database individually, starting with BDNA, then BDNA_PUBLISH.
5. Verify Cleanup
   After execution, you can verify that the objects were dropped by checking the Object Explorer or running the following SQL queries:

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'BDNA';

SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'BDNA';

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'BDNA';