1- Önce partition schema ve foknsiyonuna bağlı indexleri bul. SELECT O.Name as TableName, i.Name as IndexName, i.Type, i.type_desc as IndexType, ps.name as PartitionSchema FROM sys.objects O INNER JOIN sys.partitions p on P.object_id = O.object_id INNER JOIN sys.indexes i on p.object_id = i.object_id and p.index_id = i.index_id INNER JOIN sys.data_spaces ds on i.data_space_id = ds.data_space_id INNER JOIN sys.partition_schemes ps on ds.data_space_id = ps.data_space_id WHERE p.partition_number = 1 2- Indexleri ya rebuild et, ya da kaldır. 3- Partition function drop et 4- Partition schema drop et 5- EĞER ÜSTTEKİ DÖRT SEÇENEK DE OLMAZ İSE TABLOYU SİL SONRA şema ve fonksiyonu kaldır. DROP PARTITION SCHEME [pschema_prItemBarcode]; DROP PARTITION FUNCTION [pfnc_prItemBarcode];
