Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

fkverify

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.

Syntax

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

Where

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

TOCIndex