The following is just from my experiance with clarify
It is not a document from clarify
1.What is the meta-data?
Which are the tables associated with Meta-Data?
Ans. Meta-data is the data that stores the information
of data tables, views and their relations
Clarify Meta-Data is stored in the following adp_...tables

  1. ADP_DB_COMMENTS
  2. ADP_DB_HEADER
  3. ADP_SCH_INDEX
  4. ADP_SCH_INFO
  5. ADP_SCH_REL_INFO
  6. ADP_TBL_NAME_MAP
  7. ADP_VIEW_FIELD_INFO
  8. ADP_VIEW_JOIN_INFO

The following query gives the tables(Oracle)
select table_name from user_tables
where table_name like 'ADP%'

2. What are prop_names? where is it used?
These are the prop_names of the property in 473:5.0 form for conditions of the business rules. Note that val_type greater than zero comes with * suffix. This is the syntax of the clarify list populated from table_prop_name


select val_type,prop_name||decode(val_type,78,'*') from
table_prop_name
where val_type >= 0 and
subtype=0 and
obj_type=0 and
prop_name not like '@%'
order by prop_name

3. How can you find out all the objects associated with a form?

Answer
column title format a20
column type_name format a20
select c.title,
decode(c.type,512,'Long',516,'String',518,'List',nvl(a.type_name,c.type)) type_name
from table_ctx_obj_db c, table_window_db w, adp_tbl_name_map a
where ctx_obj2window_db=w.objid and c.type = a.type_id(+)
and w.id=&1
4.How to find all the forms that use a particular table
in their contextual objects

column title format a20
column type_name format a20
column ver_clarify format a10
column ver_customer format a10
select distinct
w.id,w.ver_clarify,w.ver_customer, a.type_name
from table_ctx_obj_db c,
table_window_db w,
adp_tbl_name_map a
where ctx_obj2window_db=w.objid and c.type = &1
and c.type=a.type_id order by w.id
Information :
 Table_string_db gives the error messages
This can be seen by the following sql
select string from table_string_db WHERE ( id >= 1600 AND id <= 1652 AND locale = 0 ) order by id asc
Information :
 Table_config_itm with scope=0 gives system variables
The value I_value, for description="license expiration", gives the expiration time in seconds.
Information :
 The following query will give the forms to be preloaded
select dlg_id, ver_clarify, ver_customer, preload from table_win_init
table_win_head has the same description
Information :
 "select objid, lic_type, paid_lic_count, max_lic_count, lic_used, times_graced from table_lic_count " Gives the License details for clarify application
License Types are
UNIV_ALL
UNIV_CS_FTS_DE
UNIV_CQ_FTS
UNIV_CLFO
UNIV_CLOO
UNIV_CLSM
UNIV_CCN
UNIV_CSA
1