[AccessD] OT ASP and MYSQL

SHOW CREATE TABLE tbl_name;
SHOW INDEX | KEYS FROM tbl_name [FROM db_name];
 
(Note, not show indexes or show key).

A.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Mwp.Reid at Queens-Belfast.AC.UK
Sent: April 21, 2003 11:35 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] OT ASP and MYSQL


Hi Arthur

Just find out which of columns 1 - x is the PK column. If you can tell me
how 
to find the PK type generally I can work out how to do it with .NET

Simply want to test a table and ID the PK column.

Martin