Hi all,
I was just wondering what the process is to truncate a single table?
Is it to go into DB Manager, select the table, go to query then TRUNCATE *table name"?
Hi all,
I was just wondering what the process is to truncate a single table?
Is it to go into DB Manager, select the table, go to query then TRUNCATE *table name"?
Distrubed guy,
Are you looking for the info contained in the following knowledge base article:
"Removing duplicate primary keys related to wireless data from Orion database tables"
http://knowledgebase.solarwinds.com/kb/questions/2505/
HTH,
Hi Pacetti,
Nope that isn't it.
We have a table within an Orion Database called NPM Wireless statistics. We have noticed that there are some problems with some of the tables within the database, some work was carried out and I was running the database maintenance task manually, however when doing so it got stuck on the NPM Wireless statistics table.
We want to truncate this table to see if it will allow us to manually run the maintenance again, however as mentioned about the table, it is locked with foreign key constraints so what we want to know is how we can manually truncate this table, or if it can be done at all?
Thanks
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.