After linking to the database an sql query is made as such [goes here]
If there are any results from the query we can use other functions to gather that information
We can us [goes here] to find that the number of total rows is   21.

We can use [goes here] to get information on each field.
Such as the field name, the table the field belongs to, the data type of the field, the number of decimals, the maximum field and a few more.


Column
Name
TableMaximum Field
Length
Data
Type
Total
Decimals
Actual Field
Width 1
recNbr fighterMatrix 4 3 0 2
oppAc fighterMatrix 2 3 0 3
level_0 fighterMatrix 2 3 0 2
level_01_02 fighterMatrix 2 3 0 2
level_03_04 fighterMatrix 2 3 0 2
level_05_06 fighterMatrix 2 3 0 2
level_07_08 fighterMatrix 2 3 0 2
level_09_10 fighterMatrix 2 3 0 2
level_11_12 fighterMatrix 2 3 0 2
level_13_14 fighterMatrix 2 3 0 2
level_15_16 fighterMatrix 2 3 0 2
level_17 fighterMatrix 2 3 0 2

Footnotes

Note 1: The data type for the field is given as a code number, 3 being an integer type, for example
Note 2: The actual field length depends on the character set used. For example, the character set utf8 has 3 bytes per character, so varchar(10) will return a length of 30 for utf8 (10*3), but return 10 for latin1 (10*1).