[phpug] Re: [OT] Get Primary Key column name using SQL

[Stig Manning]

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 nzphpug@googlegroups.com To unsubscribe, send email to nzphpug+unsubscr...@googlegroups.com -~----------~----~----~----~------~----~------~--~---