Quellcode Tabelle hier_kst_10

Das DB-Objekt selbst

create table "demoadm".hier_kst_10
  (
    mandant char(2),
    hier_nr char(5),
    kst_nr char(15),
    ebene0 char(15),
    ebene1 char(15),
    ebene2 char(15),
    ebene3 char(15),
    ebene4 char(15),
    ebene5 char(15),
    ebene6 char(15),
    ebene7 char(15),
    ebene8 char(15),
    ebene9 char(15),
    bez_ebene0 char(30),
    bez_ebene1 char(30),
    bez_ebene2 char(30),
    bez_ebene3 char(30),
    bez_ebene4 char(30),
    bez_ebene5 char(30),
    bez_ebene6 char(30),
    bez_ebene7 char(30),
    bez_ebene8 char(30),
    bez_ebene9 char(30)
  ) extent size 10 next size 8 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".ix_hier_kst_10 on "demoadm".hier_kst_10
    (mandant,hier_nr,kst_nr);

grant select on "demoadm".hier_kst_10 to "public" as "demoadm";
grant update on "demoadm".hier_kst_10 to "public" as "demoadm";
grant insert on "demoadm".hier_kst_10 to "public" as "demoadm";
grant delete on "demoadm".hier_kst_10 to "public" as "demoadm";
grant index on "demoadm".hier_kst_10 to "public" as "demoadm";