Query to get a list of the fields (from system objects)

[google.1.jvmail]

I have been asked the question, "how can I query a table and get a list
of the database properties?"

The answer, I believe is the following query:

"SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*MSys*") AND
((MSysObjects.Type)=1 Or
(MSysObjects.Type)=4 Or
(MSysObjects.Type)=6))
ORDER BY MSysObjects.Name
WITH OWNERACCESS OPTION;"


Now the question is, how can I query a table and get a list of the
fields and field properties?

I don't know quite how to get this one done. Any suggestions?

Thanks.