Datadictionary OpenWave 3.1.32

View: vwadm_externe_tableviews

Schema

public

Owner

waveuser005

Descriptions

View van alle public tabellen en views die niet tot de standaardset van OpenWave behoren

Fields

Rules

Indices

There are no indices for table vwadm_externe_tableviews

Definition

CREATE VIEW public.vwadm_externe_tableviews (
   dvnaam,
   reltype,
   extraobjecttype)
AS
SELECT pg_class.relname AS dvnaam,
   pg_class.reltype,
   'VIEW'::character(100) AS extraobjecttype
FROM pg_class
    JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid
WHERE NOT (upper(pg_class.relname::text) IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'VIEW'::text
   )) AND pg_class.relkind = 'v'::"char" AND pg_namespace.nspname = 'public'::name
UNION
SELECT pg_class.relname AS dvnaam,
   pg_class.reltype,
   'TABLE'::character(100) AS extraobjecttype
FROM pg_class
    JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid
WHERE NOT (upper(pg_class.relname::text) IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'TABLE'::text
   )) AND pg_class.relkind = 'r'::"char" AND pg_namespace.nspname = 'public'::name;

COMMENT ON VIEW public.vwadm_externe_tableviews
IS 'View van alle public tabellen en views die niet tot de standaardset van OpenWave behoren';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49