SELECT 
    t.name AS TableName,
    c.name AS ColumnName,
    i.name AS IndexName,
    i.type_desc AS IndexType,
    i.is_unique AS IsUnique,
    i.is_primary_key AS IsPrimaryKey,
    'DROP INDEX ' + QUOTENAME(i.name) + ' ON ' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) AS DropIndexCommand
FROM 
    sys.tables t
JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
JOIN 
    sys.columns c ON t.object_id = c.object_id
JOIN 
    sys.index_columns ic ON c.column_id = ic.column_id AND c.object_id = ic.object_id
JOIN 
    sys.indexes i ON ic.object_id = i.object_id AND ic.index_id = i.index_id
WHERE 
    c.system_type_id = TYPE_ID('xml') -- Filter for XML columns
ORDER BY 
    t.name, i.name, c.name;