Re: Tables without primary key
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 8 Sep 2004 05:51:15 -0400
Message-ID: <9MydnRI6YN6LS6PcRVn-uw_at_comcast.com>
Date: Wed, 8 Sep 2004 05:51:15 -0400
Message-ID: <9MydnRI6YN6LS6PcRVn-uw_at_comcast.com>
"Michael Maier" <maier_michael2003_at_yahoo.de> wrote in message
news:99f00224.0409080001.2142293e_at_posting.google.com...
| Hi,
|
| for an OnlinerReorg (SAP/ORACLE) i have to know the name of the tables
| without primary key.
|
| Where can i find it with sqlplus or abap?
|
| THX
|
| Best Regards,
| Micha
assuming SAP uses database constraints, these are all listed in the DBA_CONSTRAINTS (or USER_CONSTRAINTS) data dictionary view, CONSTRAINT_TYPE = 'P'
you can write a query outer joining this to DBA_TABLES (or USER_TABLES) and check for NULL constraint names, or use a MINUS type query
are you familiar with these techniques?
++ mcs Received on Wed Sep 08 2004 - 11:51:15 CEST