Re: scanning for auto increment columns

2002-12-27 Thread Greg Matthews
t; Sent: Saturday, December 28, 2002 8:34 AM Subject: 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 s

Re: scanning for auto increment columns

2002-12-27 Thread Mark Matthews
-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 IDENTITY

scanning for auto increment columns

2002-12-27 Thread Greg Matthews
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 MySq