Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

fc_get_hosttablename()

Retrieves the host table name of a Multi-Record Type (MRT) table. (V12.0.1)

Parameters (1)

Table ID as an INTEGER for which it will retrieve the MRT host name and UID. The returned result set consists of exactly 1 row containing four columns:

  1. The table UID or the host UID in case of multi-record type (MRT) table
  2. The c-treeDB table name
  3. The filesystem path where the table is located
  4. The filesystem name of the table

Example

call fc_get_hosttablename(1163);

ID NAME PATH PHYSICAL_NAME

-- ---- ---- ------------

1163 syssequences .\ctreeSQL.dbs\ syssequences

TOCIndex