The Livelink Database has a special set of tables that store all the information Livelink requires. To get detailed documentation on this you will need to get hold of the Livelink SDK Schema document from your Account Manager, this requires you to sign a Non Disclosure Agreement (NDA) as well, that is why you will NOT see any real detail of the Livelink database on my site.

Additionally, I would recommend doing the course 209 Livelink 9.5 Advanced Schema and LiveReports to give yourself a good grounding in the way the schema works prior to attempting anything complicated. Also of use are the following discussion groups on the OpenText Knowledge Centre - requiring a login which can be got from your internal Livelink expert or your OpenText Account Manager :

• LiveReports
• WebReports

The items in this section include :

• GetChildren
  A SQL Server User Defined Function (UDF) to list the children of a given node.