iJSQL Sql/Metadata Query Tool / News: Recent posts

CVS access is now online.

The initial release of iJSQL is available; it consists of the java source files, and should be simple enough to build.

iJSQL is a console-based interactive SQL query tool written in Java/JDBC. It goes beyond the norm in that it introduces a SQL-like syntax for interactively querying the DatabaseMetadata and ResultSetMetaData (using Java's reflection mechanism). The sorts of things this exposes are:

1) datatype, scale, and precision of a column;
2) whether or not a column autoincrements;
3) the level of ANSI SQL compliance of the database;
4) lists of reserved keywords, function names, etc.;
5) max allowed size of table / column names;
6) primary and foreign keys in a table;
7) whether or not NULL plus non-NULL equals NULL;
8) many, many more things.... read more