Datadictionary OpenWave 3.1.34 |
|
View: vwadm_foreignkeys
Datadictionary OpenWave 3.1.34 |
|
View: vwadm_foreignkeys
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_foreignkeys
Columns
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
dvnaam,
dvforeignkeyname)
AS
SELECT upper(a.conname::text) AS dvnaam,
b.attname::text AS dvforeignkeyname
FROM pg_constraint a
LEFT JOIN pg_attribute b ON a.conindid = b.attrelid
WHERE a.contype = 'f'::"char" AND upper(a.conname::text) ~~ 'CFK_%'::text;
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|