#CREATE TABLE test101( # A INT NOT NULL PRIMARY KEY, # B INT NOT NULL, # C INT NOT NULL, # CONSTRAINT "fC" FOREIGN KEY (C) REFERENCES test101(A) #); #ALTER TABLE test101 ALTER C SET NULL; #INSERT INTO test101 VALUES (100, 100, NULL); [ 1 ] #UPDATE test101 SET C = 100 WHERE C IS NULL; [ 1 ] #select * from test101; % sys.test101, sys.test101, sys.test101 # table_name % a, b, c # name % int, int, int # type % 3, 3, 3 # length [ 100, 100, 100 ] #ALTER TABLE test101 ALTER C SET NOT NULL; #DROP TABLE test101; #START TRANSACTION; #CREATE TABLE "sys"."t1" ("c0" DOUBLE,CONSTRAINT "t1_c0_unique" UNIQUE ("c0"),CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES "sys"."t1" ("c0")); #ROLLBACK; #START TRANSACTION; #CREATE TABLE "t0"("tc0" CHARACTER LARGE OBJECT NOT NULL,CONSTRAINT "t0_tc0_pkey" PRIMARY KEY ("tc0"), #CONSTRAINT "t0_tc0_fkey" FOREIGN KEY ("tc0") REFERENCES "sys"."t0" ("tc0")); #ROLLBACK; #CREATE TABLE t1(c0 FLOAT); #ALTER TABLE t1 ADD UNIQUE(c0); #INSERT INTO t1(c0) VALUES(13.38); [ 1 ] #DELETE FROM t1 WHERE true; [ 1 ] #INSERT INTO t1(c0) VALUES(0.9), (0.5), (-3), (0.4); [ 4 ] #ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t1(c0); #INSERT INTO t1(c0) VALUES(null); [ 1 ] #DROP TABLE t1;