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]
