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

[Stig Manning]

Aaron Cooper wrote, on 4/02/2009 3:08 PM: Hi Stig,   Where in that query do you define the table you are using? Hi Aaron, select COLUMN_NAME from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where CONSTRAINT_NAME = 'PRIMARY' AND CONSTRAINT_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name'; Will give you the PK for the table 'table_name' within the database 'database_name'. Cheers, Stig --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---