Datadictionary OpenWave 3.1.25

View: vwadm_missingobjects

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_missingobjects

Fields

Rules

Indices

There are no indices for table vwadm_missingobjects

Definition

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

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