Datadictionary OpenWave 3.1.25

View: vwadm_extraobjects

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_extraobjects

Fields

Rules

Indices

There are no indices for table vwadm_extraobjects

Definition

CREATE VIEW public.vwadm_extraobjects (
   dvnaam,
   extraobjecttype)
AS
SELECT vwadm_tables.dvnaam,
   'TABLE'::character(100) AS extraobjecttype
FROM vwadm_tables
WHERE NOT (vwadm_tables.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'TABLE'::text
   ))
UNION
SELECT vwadm_views.dvnaam,
   'VIEW'::character(100) AS extraobjecttype
FROM vwadm_views
WHERE NOT (vwadm_views.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'VIEW'::text
   ))
UNION
SELECT vwadm_constraints_check.dvnaam,
   'CONSTRAINT_CHECK'::character(100) AS extraobjecttype
FROM vwadm_constraints_check
WHERE NOT (vwadm_constraints_check.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'CONSTRAINT_CHECK'::text
   ))
UNION
SELECT vwadm_constraints_notnull.dvnaam,
   'CONSTRAINT_NOTNULL'::character(100) AS extraobjecttype
FROM vwadm_constraints_notnull
WHERE NOT (vwadm_constraints_notnull.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'CONSTRAINT_NOTNULL'::text
   ))
UNION
SELECT vwadm_foreignkeys.dvnaam,
   'FOREIGNKEY'::character(100) AS extraobjecttype
FROM vwadm_foreignkeys
WHERE NOT (vwadm_foreignkeys.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'FOREIGNKEY'::text
   ))
UNION
SELECT vwadm_indexes.dvnaam,
   'INDEX'::character(100) AS extraobjecttype
FROM vwadm_indexes
WHERE NOT (vwadm_indexes.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'INDEX'::text
   ))
UNION
SELECT vwadm_indexes_unique.dvnaam,
   'INDEX_UNIQUE'::character(100) AS extraobjecttype
FROM vwadm_indexes_unique
WHERE NOT (vwadm_indexes_unique.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'INDEX_UNIQUE'::text
   ))
UNION
SELECT vwadm_primarykeys.dvnaam,
   'PRIMARYKEY'::character(100) AS extraobjecttype
FROM vwadm_primarykeys
WHERE NOT (vwadm_primarykeys.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'PRIMARYKEY'::text
   ))
UNION
SELECT vwadm_tablecolumns.dvnaam,
   'TABLECOLUMN'::character(100) AS extraobjecttype
FROM vwadm_tablecolumns
WHERE NOT (vwadm_tablecolumns.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'TABLECOLUMN'::text
   ))
UNION
SELECT vwadm_viewcolumns.dvnaam,
   'VIEWCOLUMN'::character(100) AS extraobjecttype
FROM vwadm_viewcolumns
WHERE NOT (vwadm_viewcolumns.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'VIEWCOLUMN'::text
   ))
UNION
SELECT vwadm_defaults.dvnaam,
   'DEFAULT'::character(100) AS extraobjecttype
FROM vwadm_defaults
WHERE NOT (vwadm_defaults.dvnaam IN (
   SELECT tbadm_objects.dvname
   FROM tbadm_objects
   WHERE tbadm_objects.dvtype::text = 'DEFAULT'::text
   ));

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13