Schema()

Returns an ADORowset object containing metadata for the rowset.

Metadata includes field names, field types, field sizes, base table name, base catalog name, base database name, etc.

Here is the dBASE code to retrieve and display the schema rowset:

d = new adodatabase()

d.databasename = "SQLSERVERADO" //Use your ADO database alias here

d.active = true

q = new adoquery()

q.database = d

q.sql = "select * from customers"

q.active = true

s = q.rowset.schema()

inspect(s)

f = new form()

f.g = new grid(f)

f.g.anchor = 6

f.g.datalink = s

f.open()

Here is a screen shot of some of the columns within the metadata rowset:

Here is the field list (from the Inspector) for the metadata rowset: