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);
}
