This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
You are trying to refer to an alias as a column. This:
is invalid. Try "TABLE_NAME" instead.
If you would rather try a better way, have a look at the methods provided by java.sql.DatabaseMetaData. This is the better way to do it, since now your code is portable. The downside is that not all Drivers will implement all the methods. However, you are using jTDS, which I think covers them all.
Is DESCRIBE part of the ANSI standard? I didn't think it was; are you sure it is not an Oracle specific command MySQL have choosen to implement? As far as I am aware, MS SQL 2000 is ANSI-92 complient.
If you have lots of this meta data stuff to do, its probably quicker to swap to using DatabasMetaData. To build up simmilar output to how MySQL/Oracle's describe works is possible, but you'll have to do the work step by step, querying the system tables. Not quick. [ December 03, 2007: Message edited by: Paul Sturrock ]