Some databases have a unique system key (tupleid) regardless of the existence of a primary key. For SAPDB, the SYSKEY field is what I am looking for. Thank you for your assistance.
Keith Arnold -----Original Message----- From: Zabach, Elke [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 2:06 AM To: Keith; Maxdb Subject: AW: Tuple ID Keith wrote: > > Is there a way to access the tuple id's in an SAPDB query statement? > Which tuple id ??? MaxDB' records have a primary key. If it was specified by the user using the keywords PRIMARY KEY, then this is the unique identification of the record. If the user did not specify a primary key for the table, there is the (implicit added) column named SYSKEY CHAR (8) BYTE, building the primary key. This can be selected by explicit naming SELECT SYSKEY, .... FROM... It will not be returned when using select * Elke SAP Labs Berlin > Keith Arnold > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
