Raimund Jacob wrote concerning the mail of Knut Thomas > "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.
Ok, starting with version 7.3.0.21 and after loading the systables for this version there will be no differences in the number of infos returned if you ask for indices or columns of them. Only real indices (no primary keys) will be returned. Therefore no SYSPRIMARYKEYINDEX should be seen then, no matter if SQLStudio or dbmcli or whatever asks the kernel. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
