Datadictionary OpenWave 3.1.25
Previous topic Chapter index Next topic

View: vwadm_foreignkeys

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

There is no description for view vwadm_foreignkeys

 

Fields

Name

Data type

Description

dvnaam

text

 

dvforeignkeyname

text

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table vwadm_foreignkeys

 

Definition

CREATE VIEW public.vwadm_foreignkeys (
   dvnaam,
   dvforeignkeyname)
AS
SELECT
upper(pg_constraint.conname::text) AS dvnaam,
   lower(pg_constraint.conname::text) AS dvforeignkeyname
FROM pg_constraint
WHERE pg_constraint.contype = 'f'::"char" AND
   upper(pg_constraint.conname::text) ~~ 'CFK_%'::text;

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