This content has been marked as final. Show 3 replies
I never saw something like that.. it�s a security question.. or you are the database admin and know you tables names or aren�t... i do not know any command in SQL or others languages .. to list the tables names....
It's not too hard using JDBC metadata. I read http://members.aol.com/kgb1001001/Articles/JDBCMetadata/JDBC_Metadata.htm. You may want to look at the java.sql.DatabaseMetaData interface and/or google for JDBC metadata.
Sorry i was wrong ...there�s a table in MsAccess called "MSysObjects" that keeps all info about the DB... try this SQL in you ms access... "SELECT name from MSysObjects where type=1;" i tested and works...