Datadictionary OpenWave 3.1.35 |
|
View: vwadm_tablecolumncount
Datadictionary OpenWave 3.1.35 |
|
View: vwadm_tablecolumncount
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_tablecolumncount
Columns
Name | Data type | Description |
|---|---|---|
dvtablename |
information_schema.sql_identifier |
|
dncolumncount |
bigint |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwadm_tablecolumncount
Definition
dvtablename,
dncolumncount)
AS
SELECT c.table_name AS dvtablename,
count(*) AS dncolumncount
FROM information_schema.columns c
JOIN information_schema.tables 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) ~~ 'TB%'::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 |
|