Datadictionary OpenWave 3.1.35

View: vwadm_viewcolumncount

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_viewcolumncount

Columns

Rules

Indices

There are no indices for table vwadm_viewcolumncount

Definition

CREATE VIEW public.vwadm_viewcolumncount (
   dvviewname,
   dncolumncount)
AS
SELECT c.table_name AS dvviewname,
   count(*) AS dncolumncount
FROM information_schema.columns c
    JOIN information_schema.views v ON c.table_name::name = v.table_name::name
        AND c.table_schema::name = v.table_schema::name
WHERE (c.table_schema::name <> ALL (ARRAY['pg_catalog'::name,
   'information_schema'::name])) AND upper(c.table_name::text) ~~ 'VW%'::text
GROUP BY c.table_name;

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10