"Zabach, Elke" wrote:
> After some mail from him in which he told, that
> SQL Studio results in 91 columns and
> DBMCLI in 51
> I found out the following:
>
> SQL Studio uses ODBC. For some reason (I have forgotten, we have to check
> if it is necessary any more) applications using ODBC will receive not only
> those indexcolumns DBMCLI and C++Precompiler and the catalog-extract
> will see (and which are used in indexes specified),
> but additionally those 'indexes' named SYSPRIMARYKEYINDEX , i.e. for all
> tables the primary key-columns as if they were was specified as index.
>
> Depending what you want (inclusive primary key or not) some additional
> WHERE indexname <> 'SYSPRIMARYKEYINDEX'
the same is true for JDBC (.18 kernel, .21a jdbc drivers):
selecting * from ind_uses_col contains all automatic primary key
indices.
... it doesnt disturb me, but i observed it...
bye,
Raimund
--
Raimund Jacob
\|/ ____ \|/
Pinuts Media+Science GmbH "@'/ ,. \`@"
Potsdamer Str. 96 /_| \__/ |_\
D-10785 Berlin \__U_/
http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
