Using SQL, you're able to query those metadata tables to get the names of the databases, the columns in the database, and other information.
For advanced users, the data may be retrieved using SQL from the Web interface.
For structured data with well understood relationships one may use SQL or the relational model.
Using SQL, one can easily create tables that share the same structure as already existing tables.
Also, the UDF's code is not allowed to use dynamic SQL.
Within relational databases using SQL, entity integrity is enforced by adding a primary key clause to a schema definition.
I know you have been working on the database using excel, but we need to use SQL.
The same program using free calculations and embedded SQL:
Make it so that it it can be queried externally using SQL via web service etc.
The front end is designed using Swings and back-end SQL.