I am unable to drop partitioned index due to partition scheme and partition function existence.
Table has a Primary Key, a Clustered Index and non clustered indexes.
I am running the following query:
drop partition scheme scheme_name
I am getting this error:
Msg 7717, Level 16, State 1, Line 1
The partition scheme "scheme_name" is currently being used to partition one or more tables.
I tried recreating indexes by dropping them but I still get the same error.