The Data Studio


If you are installing the Data Quality Monitor or the Data Profiler, you will find more comprehesive instructions and explanations at Data Quality Tools. For the the TableDefinition tool, the latest information is currently here - this will also be updated soon.


TableDefinition

Download>

TableDefinition.jar

Run TableDefinition

If you run TableDefinition without parameters, it will tell what it needs, like this:

$ java -jar TableDefinition.jar

Usage: TableDefinition configuration-file [schema-override [table-override]]

    configuration: path of configuration file, always needed
    schema:        name of schema containing table definitions to be extracted, needed if table specified
    table:         name of table for which definition to be extracted

If only configuration-file is specified, extract the definition of the table in the configuration-file.
If schema is not specified in configuration-file, and not overridden, generate list of schemas in this database.

If table is not specified in configuration-file, and not overridden, generate a list of tables in this schema, with the number of rows in each table.
If schema and table are specified, generate 'create table ...' statement for this table.        
    

JDBC Drivers

All database access is done using JDBC. There are JDBC drivers for every SQL database (as far as I know) and some that have only a passing resemblance to SQL. A quick search should find the one you need and most (if not all) can be downloaded free-of-charge.