internal static List <string> getTableInfo(DbConnection con, string table) { var data = new List <string>(); if (!sql.Utils.IsDbEmbedded(sql.Utils.GetDbTypeEnum(con))) { string command = ""; try { command = new SqlBuilderFactory(con).Create(con.Database).getTableInfo(table); using (var reader = new DbCommandFactory(con, command).Create().ExecuteReader()) { while (reader.Read()) { data.Add("~Rows:" + (reader.IsDBNull(5) ? "" : reader.GetString(5))); data.Add("AvgLen:" + (reader.IsDBNull(0) ? "" : reader.GetString(0))); data.Add("Length:" + (reader.IsDBNull(1) ? "" : reader.GetString(1))); data.Add("Free:" + (reader.IsDBNull(2) ? "" : reader.GetString(2))); data.Add("AI:" + (reader.IsDBNull(3) ? "" : reader.GetString(3))); data.Add("Collation:" + (reader.IsDBNull(4) ? "" : reader.GetString(4))); } } } catch (DbException ex) { command = ex.Message; #if DEBUG Console.WriteLine(ex.Message); #endif } Terminal.MainTerminal.AppendText(command); } return(data); }