how can i print the primary keys of table in ms access in php code

hawkeye000 · #1 (**permalink**) 12-18-08, 02:06 PM

how can i print the primary keys of table in ms access in php code
i try odbc_primarykeys but it no suitable
pleaaaaase if anyone has the idea
thnx

maneetpuri · #2 (**permalink**) 12-20-08, 05:53 AM

Hi,

I don’t think there is any direct way of doing this. But a way out is, fetch the complete structure of the table and parse it field by filed, for which all fields you get the Primary Key constrain, display it.

Cheers,

~Maneet Puri

hawkeye000 · #3 (**permalink**) 12-20-08, 01:35 PM

is there a function used to display the complete structure from ms access???

-[OnTarget]- · #4 (**permalink**) 12-20-08, 06:20 PM

Some good comments (basically the first one) on the PHP website: http://us.php.net/manual/en/function.odbc-columns.php

hawkeye000 · #5 (**permalink**) 12-21-08, 08:13 AM

yes dear i saw it before but also i cant dispaly all structure basically brimarykey field
any help please

hawkeye000 · #6 (**permalink**) 12-23-08, 05:07 AM

any help please ?

infinitylimit · #7 (**permalink**) 12-23-08, 05:24 AM

I don't know if this will help in this case but what I do is drop back to SQL. I believe DESCRIBE tablename; will at least give you a bunch of information regarding the structure for most SQL based DBs