enter image description here There is a DB, in it some tables. Sectioning is put on the index. How to disable it? They advised to re-create, tried, the index is not deleted.

  • "The index is not deleted" Does it give some error or is it silently deleted? - i-one
  • @ i-one I updated the question - propro17
  • The error says that you are not deleting the index, but the partition scheme (partition scheme) that is used. The link is an example of a query to the system catalogs, having executed which, you can see which tables and indexes use partitioning schemes. How to remove sectioning link you have already given. - i-one
  • one
    @ propro17 Add the error code to the body of the question ( edit button) as text, not an image. - Nicolas Chabanovsky ♦

1 answer 1

In the properties of a partitioned index, in the Storage section there is a switch between storing the index in a Filegroup or Partition scheme. Of course, after changing the repository, the index will be recreated.