如何使用SMO与SQL Server删除并重新创建主键索引？

using System;
using System.Data.SqlClient;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

public class Program
{
    public static void Main()
    {
        // 设置数据库连接字符串
        string connectionString = "Data Source=YOUR_SERVER_NAME;Initial Catalog=YOUR_DATABASE_NAME;Integrated Security=True";

        // 创建数据库连接
        SqlConnection connection = new SqlConnection(connectionString);

        // 创建SMO服务器对象
        Server server = new Server(new ServerConnection(connection));

        // 指定要操作的表
        Table table = server.Databases["YOUR_DATABASE_NAME"].Tables["YOUR_TABLE_NAME", "YOUR_SCHEMA_NAME"];

        // 获取主键索引
        Index primaryKeyIndex = table.Indexes["PK_" + table.Name];

        // 删除主键索引
        primaryKeyIndex.Drop();

        // 重新创建主键索引
        primaryKeyIndex = new Index(table, "PK_" + table.Name);
        primaryKeyIndex.IndexKeyType = IndexKeyType.DriPrimaryKey;
        primaryKeyIndex.IsClustered = true;
        primaryKeyIndex.IndexedColumns.Add(new IndexedColumn(primaryKeyIndex, table.Columns["YOUR_PRIMARY_KEY_COLUMN_NAME"]));
        primaryKeyIndex.Create();

        // 提交更改
        server.ConnectionContext.CommitTransaction();
    }
}