scanning for auto increment columns

All, I'd like to be able to query MySql using the JDBC driver to determine which tables have auto incremented columns. In MSSQL I can retrieve data from the syscolumns and sysobjects tables to find out which columns are IDENTITY columns, but have had no luck trying to do something similar in

Re: scanning for auto increment columns

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greg Matthews wrote: All, I'd like to be able to query MySql using the JDBC driver to determine which tables have auto incremented columns. In MSSQL I can retrieve data from the syscolumns and sysobjects tables to find out which columns are

Re: scanning for auto increment columns

: scanning for auto increment columns All, I'd like to be able to query MySql using the JDBC driver to determine which tables have auto incremented columns. In MSSQL I can retrieve data from the syscolumns and sysobjects tables to find out which columns are IDENTITY columns, but have had