CREATE DATABASE "RI" PATH 'C:\Temp\RI'
 
CREATE TABLE "TestPK"
(
"StockCode" VARCHAR(20) COLLATE "UNI",
CONSTRAINT "PrimaryKey" PRIMARY KEY ("StockCode")
)
VERSION 1.00
INDEX PAGE SIZE 8192
BLOB BLOCK SIZE 1024
PUBLISH BLOCK SIZE 1024
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768
 
CREATE TABLE "TestFK"
(
"Container" VARCHAR(20) COLLATE "UNI",
"StockCode" VARCHAR(20) COLLATE "UNI"
)
VERSION 1.00
INDEX PAGE SIZE 8192
BLOB BLOCK SIZE 1024
PUBLISH BLOCK SIZE 1024
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768
 
F5
 
ALTER TABLE "TestFK"
ADD CONSTRAINT "Container" FOREIGN KEY ("Container") REFERENCES "TestPK" ("StockCode") ON UPDATE NO ACTION ON DELETE RESTRICT
 
F5
 
ALTER TABLE "TestFK"
ADD CONSTRAINT "StockCode" FOREIGN KEY ("StockCode") REFERENCES "TestPK" ("StockCode") ON UPDATE NO ACTION ON DELETE RESTRICT
 
F5
 
ALTER TABLE "TestFK"
DROP CONSTRAINT "Container"