Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table customer (custnum int primary key)
create table widget (stocknum int primary key)
create table purchased (
    custnum int,
    stocknum int, 
    pdate date,
    primary key (custnum, stocknum, pdate),
    foreign key (custnum) references customer,
    foreign key (stocknum) references widget
); 
select constraint_name
from user_cons_columns
where table_name = 'purchased'
and column_name = 'custnum';
select constraint_name
from user_cons_columns
where table_name = 'PURCHASED'
and column_name = 'CUSTNUM';


CONSTRAINT_NAME


SYS_C00113057

SYS_C00113058


select *
from user_constraints
where table_name = 'PURCHASED';


OWNER
CONSTRAINT_NAME
CONSTRAINT_TYPE
TABLE_NAME
SEARCH_CONDITION
SEARCH_CONDITION_VC
R_OWNER
R_CONSTRAINT_NAME
DELETE_RULE
STATUS
DEFERRABLE
DEFERRED
VALIDATED
GENERATED
BAD
RELY
LAST_CHANGE
INDEX_OWNER
INDEX_NAME
INVALID
VIEW_RELATED
ORIGIN_CON_ID


FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113057
P
PURCHASED
null
null
null
null
null
ENABLED
NOT DEFERRABLE
IMMEDIATE
VALIDATED
GENERATED NAME
null
null
05-APR-22
FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113057
null
null
3

FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113058
R
PURCHASED
null
null
FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113055
NO ACTION
ENABLED
NOT DEFERRABLE
IMMEDIATE
VALIDATED
GENERATED NAME
null
null
05-APR-22
null
null
null
null
3

FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113059
R
PURCHASED
null
null
FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113056
NO ACTION
ENABLED
NOT DEFERRABLE
IMMEDIATE
VALIDATED
GENERATED NAME
null
null
05-APR-22
null
null
null
null
3


select *
from user_cons_columns
where table_name = 'PURCHASED';


OWNER
CONSTRAINT_NAME
TABLE_NAME
COLUMN_NAME
POSITION


FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113057
PURCHASED
CUSTNUM
1

FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113057
PURCHASED
STOCKNUM
2

FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113057
PURCHASED
PDATE
3

FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113058
PURCHASED
CUSTNUM
1

FIDDLE_BJUIBGLGKURXCHPUOXQN
SYS_C00113059
PURCHASED
STOCKNUM
1


select uc.constraint_name
from user_constraints uc
join user_cons_columns ucc on ucc.constraint_name = uc.constraint_name
where uc.table_name = 'PURCHASED'
and uc.constraint_type = 'R'
and ucc.column_name = 'CUSTNUM';


CONSTRAINT_NAME


SYS_C00113058

OWNER	CONSTRAINT_NAME	CONSTRAINT_TYPE	TABLE_NAME	SEARCH_CONDITION	SEARCH_CONDITION_VC	R_OWNER	R_CONSTRAINT_NAME	DELETE_RULE	STATUS	DEFERRABLE	DEFERRED	VALIDATED	GENERATED	BAD	RELY	LAST_CHANGE	INDEX_OWNER	INDEX_NAME	INVALID	VIEW_RELATED	ORIGIN_CON_ID
FIDDLE_BJUIBGLGKURXCHPUOXQN	SYS_C00113057	P	PURCHASED	null	null	null	null	null	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	null	null	05-APR-22	FIDDLE_BJUIBGLGKURXCHPUOXQN	SYS_C00113057	null	null	3
FIDDLE_BJUIBGLGKURXCHPUOXQN	SYS_C00113058	R	PURCHASED	null	null	FIDDLE_BJUIBGLGKURXCHPUOXQN	SYS_C00113055	NO ACTION	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	null	null	05-APR-22	null	null	null	null	3
FIDDLE_BJUIBGLGKURXCHPUOXQN	SYS_C00113059	R	PURCHASED	null	null	FIDDLE_BJUIBGLGKURXCHPUOXQN	SYS_C00113056	NO ACTION	ENABLED	NOT DEFERRABLE	IMMEDIATE	VALIDATED	GENERATED NAME	null	null	05-APR-22	null	null	null	null	3