The columns metadata of a table

GetTableColumnsSchema.cs

using var conn = new SqlConnection(connectionString);
var connectionStringInfo = new SqlConnectionStringBuilder(connectionString);
var dbName = connectionStringInfo.InitialCatalog;
var sql = $"SELECT * FROM {tableName} WHERE 1 = 2";
using var command = new SqlCommand(sql, conn);
conn.Open();
using var reader = await command.ExecuteReaderAsync(CommandBehavior.KeyInfo);
var columnSchema = reader.GetColumnSchema();