public static MySQLTable GetTable(MySQL sql, string table) { MySQLTable t = new MySQLTable(); t.Name = table; foreach (DataRow row in sql.RetrieveDataTable($"SHOW COLUMNS FROM {table}").Rows) { t.Columns.Add(new ColumnProperty(MySQLHelper.Instance, (string)row["Field"], (string)row["Type"])); } return(t); }
public static List <string> GetTables(MySQL sql) { return(sql.RetrieveDataTable($"select * from information_schema.tables where TABLE_SCHEMA = '{sql.Database}'").Select().Select(x => (string)x["TABLE_NAME"]).ToList()); }