TableColumnsInfo

Class: TMMConnection


function TableColumnsInfo(const ATableName: string;
           out AColumns: TJSONArray): Boolean;

Retrieves INFORMATION_SCHEMA.COLUMNS metadata for all columns of a table, ordered by ORDINAL_POSITION. AColumns receives a cloned TJSONArray owned by the caller; nil on failure. Free with AColumns.Free when done.

Fields in each element: table_schema, table_name, column_name, ordinal_position, column_type, data_type, is_nullable, column_default, character_maximum_length, numeric_precision, numeric_scale, datetime_precision, character_set_name, collation_name, column_key, extra, column_comment, generation_expression.


See Also

(C) 2026 Easygate, Lda