This article provides a method for removing all tables, views, and stored procedures from the BDNA and BDNA_PUBLISH databases using a prewritten SQL script. This process is typically used when preparing an environment for a clean reinstallation or troubleshooting database corruption issues.
CAUTION: This action is irreversible. Dropping database objects will result in data loss. Only perform this operation if you have a full backup and understand the implications.
- Download the SQL Script
Download the script that removes allBDNAandBDNA_PUBLISHdatabase objects from the following secure link:
Download SQL Cleanup Script - 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 theBDNAandBDNA_PUBLISHschemas.
- Backup Your Data
Ensure you have recent database backups before proceeding. - Run the Script
Execute the script using SQL Server Management Studio (SSMS) or your preferred SQL client:- Connect to the server hosting the
BDNAandBDNA_PUBLISHdatabases. - Open the downloaded .sql file.
- Execute the script against each database individually, starting with
BDNA, thenBDNA_PUBLISH.
- Connect to the server hosting the
- 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';
Related Articles
Create a custom role for BDNA and BDNA_PUBLISH 11Number of Views Cannot drop index ?PK_ComplianceDomain? because it enforces the full-text key for table or indexed view 10Number of Views SCCM Database Tables & Views used during System Center Inventory Import 7Number of Views Import writers step "Syncs the reconcile staging tables to main tables" step may fail with error: 'The INSERT statement co… 10Number of Views Failed to apply update_tables_sqlserver2041175501.sql patch during upgrade from Data Platform 5.5.77 to 5.5.78 27Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago