Quellcode Tabelle hier_ktr_hn

Das DB-Objekt selbst

create table "demoadm".hier_ktr_hn
  (
    mandant char(2),
    hier_nr char(5),
    hier_name char(30)
  ) extent size 10 next size 8 lock mode row;

Abhängige Objekte, Rechte

create unique index "demoadm".ix_hier_ktr_hn on "demoadm".hier_ktr_hn
    (mandant,hier_nr);

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