Oracle Database

[Former Member]

I am examining the underlying Oracle database of my SAP

system. I am looking at several tables to see that Primary and

Foreign Keys were created.

When I examine table EBAN, for example, I see no Primary Key.

Nor do I see any Foreign Keys created.

My system functions correctly, but I don't understand why

keys and relationships are missing.

[Former Member]

Maybe you should ask this in one of the database forums. If so, close this first.

Rob

[Former Member]

Hi Gregory,

if you mean database enforced constraints like Primary key (P) or foreign key (R):

in SAP - nope. It's the database independence thing that comes into play here.

They enforce this over the application - no database inside checks.

However they implement their own referentiell integrity over columns and their check tables,

primary key by unique indexes (key fields NOT NULL).

If you start this query it returns 0:

select count(*) ncons from all_constraints where owner ='SAPR3' and 
CONSTRAINT_TYPE in ('P','R')

bye

yk