TMMTableColumn

Declared in: EDBMMUtils

type
  TMMTableColumn = record
    TableName  : string;
    ColumnName : string;
    ColumnType : string;
  end;

  TMMTableColumnArray = TArray<TMMTableColumn>;

Lightweight record representing one column entry in a TMMConnection.DatabaseStructure array.
Each element describes a single column of a BASE TABLE in the connected MySQL/MariaDB database.

Field	Description
`TableName`	Table name (BASE TABLE only; views are excluded)
`ColumnName`	Column name
`ColumnType`	Full MySQL column type including parameters, as returned by `INFORMATION_SCHEMA.COLUMNS.COLUMN_TYPE` (e.g. `'int'`, `'varchar(100)'`, `'decimal(10,2)'`)

TMMTableColumnArray is the array type used by TMMConnection.DatabaseStructure.

DatabaseStructure is sorted by table name then by column ordinal position, so iterating the array in order visits each table’s columns in their declared sequence.

TMMTableColumn carries only the information needed for a schema browser. For full column metadata (nullability, charset, collation, default, key, generated expression, etc.) use GetTableColumns or GetColumnInfo, which return TMMColumnInfo.

TMMTableColumn

See Also