About AR System Forms in Database

How to go about a list of forms/fields in Database

In order to do this, you need direct SQL Access:

To get the schemaid for a particular form:

• Select schemaid from arschema where name=‘HPD:HelpDesk’

To get a list of forms and corresponding “T” tables:

• Select name,schemaid from arschema order by name

To get a list of all fields for a schema (e.g., schema 120):

• Select fieldname,fielded from field where schemaid=120

To get a list of all forms and fields:

• Select arschema.name,field.fieldname,field.fieldidfrom arschema,fieldwhere (arschema.schemaid=field.schemaid) order by arschema.name,field.fieldname

Please note that this is a brief note and you can go through the bmc docs for in-depth info about this topic.