ODBC Formula to Get Number of Fields in Table

Getting the number of fields available in table is possible in ODBC, using the sample query below. The table name 'TRANSACTIONS' used in the example can be replaced with other table names.

SELECT count(*)
FROM OA_COLUMNS
WHERE table_name = 'TRANSACTIONS'