[ Main Menu ] [ Extension Tools Menu ] [ Lite Edition Menu ]

<iSQLTABLES> Tag

<iSQLTABLES
	[DBNAME="datasource name"]	(From Registry)
	[LOGIN="uid/pword"]	(From Registry)
	TYPES="a string"
	QUALIFIER="sql database name"	("")
	>

Usage This gets all the database tables in the specified datasource. String is a comma separated list sequence delimited of the SQL table types. The qualifier is the database name in SQL server

For example: "'TABLE','VIEW','SYSTEM TABLE','GLOBAL TEMPORARY','LOCAL TEMPORARY','ALIAS','SYNONYM'"

This string is passed to the driver, and the exact list is database dependent.

iSQLTABLES Example
Example Source Code
Top

Usage	This gets all the database tables in the specified datasource. String is a comma separated list sequence delimited of the SQL table types. The qualifier is the database name in SQL server
	For example: "'TABLE','VIEW','SYSTEM TABLE','GLOBAL TEMPORARY','LOCAL TEMPORARY','ALIAS','SYNONYM'"
	This string is passed to the driver, and the exact list is database dependent.