Incode Systems Home Page Incode Systems, Inc.


SQLMETA



(Windows Program Win95 or higher)

SQLMeta - Copyright (C) Incode Systems, Inc. 2002-2012.

Usage: DRIVERS OutFileName[.txt] LogFileName[.log]
Returns a list of ODBC Drivers

Usage: DSN OutFileName[.txt] LogFileName[.log]
Returns a list of ODBC Data Source Names

Usage: TABLES(TableType) OutFileName[.txt] LogFileName[.log]
Returns a list of table names
TableType is optional and may be one of the following:
TABLE,VIEW,SYSTEM TABLE,GLOBAL TEMPORARY,LOCAL TEMPORARY,ALIAS,SYNONYM
(or a data source - specific type identifier)

Usage: COLUMNS(TABLENAME) OutFileName[.txt] LogFileName[.log]
Returns a list of table columns and attributes.
If TABLENAME is * all table columns are returned.

Usage: FOREIGNKEYS(TABLENAME) OutFileName[.txt] LogFileName[.log]
Returns tab-delimited data about foreign keys that reference TABLENAME.
Use -r option to return data about foreign keys that TABLENAME references.

Usage: PRIMARYKEYS(TABLENAME) OutFileName[.txt] LogFileName[.log]
Returns a list of table columns which make up the primary key.

Usage: INDEXES(TABLENAME) OutFileName[.txt] LogFileName[.log]
Returns tab-delimited data about all indexes for TABLENAME.

Usage: CREATE(Target) OutFileName[.txt] LogFileName[.log]
Returns a SQL script to create all tables (of TableType TABLE).
Target is optional and is the root name of an INI file containing:
[Options]
SQLStatementDelim=will be inserted between SQL statements. Default= (Use to escape LF, CR, and TAB characters)
TablePrefix=will be inserted before all table namesQuoteIdentifiers=1 will cause all identifiers to be doubled quoted[SQLTypes]
Types listed in this section are:
CHAR,NUMERIC,DECIMAL,INTEGER,SMALLINT,FLOAT,REAL,DOUBLE,DATE,TIME,TIMESTAMP,
VARCHAR,LONGVARCHAR,BINARY,VARBINARY,LONGVARBINARY,BIGINT,TINYINT,BIT
You need only list types which require translation.

If any FileName is not given, or CON, standard output is used.
Options: (case sensitive, may be preceeded with a - or /)
-cs Driver Connect String (if -cs is used -d -db -U and -P are ignored)
-d ODBC Data Source Name
-db Database Name (override Database defined in DSN)
-i Initialization File
-U login
-P password
-v Verbose mode, write SQL_SUCCESS_WITH_INFO messages to log
-h Header row (default)
-o Order (sort) the output alphabetically
-q Quote identifiers, if needed (default)
-q+ Always quote identifiers
-q- Never quote identifiers
-r References instead of Referenced By (use with ForeignKey)
-? help (this screen)
-help (this screen)
Any parameter containing spaces should be surrounded by double quotes.
A minus sign after the option turns it off (example: -h- for No Header row).
Current directory and program directory is checked for SQLMeta.ini
which is a text file in the form: Option=OptionValue example: d=Data Source Name
An initialization file may specified on the command line like this: Login and password optional if DBMS supports trusted connections.

Version 1.9.2 http://www.incodesystems.com
mailto:infoTo see complete usage, type: SQLMeta /? | MORE