SQL Question

Yes, it's possible. It depends (however) on the database you're using.

Most databases (AFAIK all, but I'm sure there's an exception somewhere) use meta-tables to hold information about their tables and columns.

In oracle, it's SYS.ALL_TABLES (or it's kin SYS.USER_TABLES / SYS.DBA_ALL_TABLES - refer to Oracle Table Reference for more versions)
In SQLServer, it's DBO.SYSOBJECTS

There is *no* standard for this though, so every database is different.
However, though ODBC,JDBC,DAO etc there are calls in the API to enumerate the tables. Each driver implements this in a DB-specific fashion to hide the underlying implementation.

Without wanting to sound facetious though, asking an "is it possible" question in a software engineering assignment is just asking for trouble. ie: Is it possible to access the "hot coffee" scenes in GTA:SA? Easy, intended or supported, no. Possible, well obviously.

Ok let me be a little more specific then... =D

How do I find the number of tables in a PostgreSQL database using JDBC? I am totally stuck, I've Googled it and can't find anythiung. =(

Aaaaaaaaaa-[url="http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html"]choo![/url]

A java link flew out of your nose? How fitting ;)

Did you manage to solve this one Kane? Happy to explain further if you want...

I did manage to figure something out, it most definately wasn't the best way to do things but it worked... [:p]

I would post the code I wrote but I think everyone would throw up all over their keyboards [;)]

Thanks for ur help mcdrewski!