Product Documentation

SQL Operations Guide

Previous Topic

Next Topic


It was possible that foreign key constraints could be violated in some versions of FairCom DB (V8.27 prior to revision 8662). A The Foreign Key Constraint Verification utility, fkverify, is available to check all Foreign Key constraints in a database to insure that referential integrity is maintained, and log any exceptions to a file.

This utility connects directly to FairCom DB SQL through the direct link ODBC interface thus is cross platform, and requires no additional components.


fkverify [-s server][-p port][-d database]-a password


  • -s Machine name (default: localhost)
  • -p Port (default: 6597)
  • -d Database (default: ctreeSQL)
  • -a Admin Password