Kod: Tümünü seç
CREATE TABLE "POLICELER"
(
"TCNO" VARCHAR(11) CHARACTER SET WIN1254,
"POLICENO" VARCHAR(15) CHARACTER SET WIN1254 NOT NULL,
"POLICETURU" VARCHAR(10) CHARACTER SET WIN1254,
"ARACPLAKA" VARCHAR(10) CHARACTER SET WIN1254 NOT NULL,
"BASLAMATARIHI" DATE,
"BITISTARIHI" DATE,
"KALANGUN" INTEGER,
"DEKONT" VARCHAR(15) CHARACTER SET WIN1254,
CONSTRAINT "POLICELER_PK" PRIMARY KEY ("POLICENO", "ARACPLAKA")
);
ALTER TABLE "POLICELER" ADD CONSTRAINT "MUSTERILER_FK" FOREIGN KEY ("TCNO") REFERENCES MUSTERILER ("TCNO") ON DELETE CASCADE;
KALANGUN:= BITISTARIHI-DATE;
nasıl trigger olusturulur...