CREATE TABLE [DirUnitMeasure] (
  [DirUnitMeasureID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
  [DirUnitMeasureName] TEXT(16) NOT NULL, 
  [DirUnitMeasureDesc] TEXT(64));

CREATE TABLE [DirNomen] (
  [DirNomenID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
  [DirNomenName] TEXT(256) NOT NULL, 
  [DirUnitMeasureID] INTEGER NOT NULL CONSTRAINT [FK_DirNomen_DirUnitMeasureID] REFERENCES [DirUnitMeasure]([DirUnitMeasureID]), 
   ...

DELETE FROM DirUnitMeasure WHERE DirUnitMeasureID=777

 PRAGMA foreign_keys = ON;

SQLite> PRAGMA foreign_keys;
0