检查数据表列名称是否为默认列名称C#

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString";
        string tableName = "YourTableName";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 获取列信息
            SqlCommand command = new SqlCommand($"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{tableName}'", connection);
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                string columnName = reader["COLUMN_NAME"].ToString();

                // 检查列名称是否为默认列名称
                if (columnName.StartsWith("Column"))
                {
                    Console.WriteLine($"列名称 '{columnName}' 是默认列名称。");
                }
                else
                {
                    Console.WriteLine($"列名称 '{columnName}' 不是默认列名称。");
                }
            }

            reader.Close();
        }
    }
}