This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
My question is, is it possible to look at the structure of a database... for example table names, the columns in each table and each columns type? It would seem that MetaData (data about the data)would do that. However I have played with it for a few minutes and it seems that is not the case Thanks, Bill
Well, don't know if you are using the correct Interfaces. ResultSetMetaData can determine column titles and column types to name a couple, but the 2 you had asked about. DatabaseMetaData will allow you to discover Table Names, Priviliges, Stored Procedures, etc.