Hi Holger,
works for me.
Thanks :-)
Ralf
Becker, Holger schrieb:
Ralf Becker wrote:
I need to find out the column-names of the primary key of a table.
Primary keys seem not to be included in the INDEXES view.
Any help appreciated :-)
Try:
select * from columns where tablename = <tablename> and mode = 'KEY' order by pos
Kind regards Holger
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
