toSQL method

  1. @override
String toSQL()
override

Generates the SQL CREATE TABLE statement for this table.

Returns a complete MySQL CREATE TABLE statement including all fields, engine, charset, and collation specifications.

Implementation

@override
String toSQL() {
  String sql = 'CREATE TABLE `$name` (';
  sql += fields.map((field) => field.toSQL()).join(', ');
  sql += ') ENGINE=$engine DEFAULT CHARSET=$charset COLLATE=$collation;';
  return sql;
}