topic Oracle Database in Application Development and Automation Discussions

Oracle Database

Former Member — Sun, 08 Mar 2009 17:24:44 GMT

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 — Sun, 08 Mar 2009 18:47:23 GMT

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

Rob

Former Member — Mon, 09 Mar 2009 12:51:31 GMT

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