title: Cannot delete "system" partition schemes created by FullText catalogs
body: <p>So we've got a bunch of apps running on our SQL servers, and today we realised that a number of them had a bunch of Partition Schemes/Functions that we didn't create.</p>
  
  <p>The partition schemes and functions were called <code>ifts_comp_fragment_data_space_{hash}</code> and <code>ifts_comp_fragment_partition_function_{hash}</code> respectively.</p>
  
  <p>Digging deeper, we realised that they are marked as system entries (<code>is_system</code> set to 1 in <code>sys.partition_schemes</code>) which means we can't even delete them.</p>
  
  <p>After some research we found out that SQL server will create them to partition the fulltext catalogs if they become too large, or something like that <a href="https://stackoverflow.com/questions/14472978/full-text-search-auto-partition-schemes-and-functions">see here</a>. The problem is - we just deleted all the catalogs, and these were left abandoned, with NO way of clearing them out.</p>
  
  <p>I wouldn't worry too much, except I NEED to delete them, since I'm trying to export our DB as a .bacpac file, and that crashes complaining that the DB contains partition schemes/functions and they're not supported.</p>
  
  <p>Is there ANY way of forcing the SQL server to drop those objects, or any other alternative that I could do?</p>