Quellcode View nmv_v1_gewerbe

[ Überblick   Tabellen  Views  Prozeduren  Trigger  nmv_v1_gewerbe ]

Das DB-Objekt selbst

create view "demoadm".nmv_v1_gewerbe (nmv_nmvid,nmv_uniqname,nmv_name,nmv_kurz,nmv_text) as
  select x0.nmv_nmvid ,x0.nmv_uniqname ,x0.nmv_name ,x0.nmv_kurz
    ,x0.nmv_text from "demoadm".numverw x0 where ((x0.nmv_nmvid
    >= 260030 ) AND (x0.nmv_nmvid <= 260039 ) ) ;

Abhängige Objekte, Rechte

grant select on "demoadm".nmv_v1_gewerbe to "public" as "demoadm";

HTML-Autor: Rohloff, Datenbank: demodb, Datenstand: 31.05.00 17:07