Extra TTBL tables in Quality Center project

  • Questions
  • Extra TTBL tables in Quality Center project
Question ID: 107116
0
0

We are preparing for an upgrade and noticed one of our projects has thousands of tables that start with "TTBLCL". After doing some reading, I’ve found that this were temporary tables and should have been removed at some point. This is causing an issue when trying to verify the projects as the verify just keeps seeing the extra tables. I know I could create an exception file, but would rather not carry this unneeded data forward in our upgrade. Does anyone know of a way to delete this tables in mass rather than having to delete one by one?

Marked as spam
Posted by (Questions: 122, Answers: 3)
Asked on September 27, 2016 6:08 pm
43 views
Answers (1)
0
Private answer

We ran into the same issue during our upgrade. Our DBA ran the below SQL directly on the DB Server and it cleared all the TTBL tables. It took around 20 minutes to run for 50,000 tables, but once complete the tables were gone.

DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL = 'DROP TABLE ' + (SELECT STUFF((SELECT ', ' + 'td.' + name FROM sys.tables WHERE name like 'TTBLCL_%' FOR XML PATH ('')), 1, 1, ''))
EXECUTE SP_EXECUTESQL @SQL

Marked as spam
Posted by (Questions: 3, Answers: 168)
Answered on September 27, 2016 6:08 pm
EyeOnTesting