What about SHOW COLUMNS FROM TABLE WHERE KEY = 'PRI' :) Keith Aaron Cooper wrote: > Hi Stig, > > Where in that query do you define the table you are using? > > ----- Original Message ----- > *From:* Stig Manning <mailto:[email protected]> > *To:* [email protected] <mailto:[email protected]> > *Sent:* Wednesday, February 04, 2009 4:53 PM > *Subject:* [phpug] Re: [OT] Get Primary Key column name using SQL > > Hi Aaron, > > You can perform SQL statements on the INFORMATION_SCHEMA table. > > So you can do a lookup like > > select CONSTRAINT_SCHEMA, TABLE_NAME, COLUMN_NAME from > KEY_COLUMN_USAGE where CONSTRAINT_NAME = 'PRIMARY'; > > Or define the CONSTRAINT_SCHEMA to specify a DB. > > Cheers, > Stig > > *Aaron Cooper wrote, on 4/02/2009 2:39 PM:* >> Hi All, >> >> Can't find anything on this in the docs. Does anyone know of a >> way off the top of their head how you can return the name of a >> table's primary key using SQL. >> >> I've figured out how to get foreign keys using the >> REFERENCED_COLUMN_NAME constant, but there doesn't appear to be >> any such constant for Primaries. >> >> Cheers >> Aaron >> >> > > > > >
--~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
