Removing collection from the database that didn’t exist in the console

I notice there is some collection missing in console but exist in database. After do some research, it will become an issue while upgrading from SCCM 2007 to SCCM 2012.

First, run sql below:

Select * from collections

Then identified which collection does not appear in console and delete by sql below:

DELETE FROM collections
WHERE CollectionName='Your Collection'

If you are interested to know more about the issue, Check It Out

Warning: It is not supported to modify the ConfigMgr database in any way.