Dbinfo()

Retrieves information about the underlying database/tables

Usage

QUERY = Dbinfo(
				
					
					
						datasource, 
					
				
					
					
						type, 
					
				
					
					
						dbname, 
					
				
					
					
						table, 
					
				
					
					
						pattern, 
					
				
					
					
						username, 
					
				
					
					
						password
					
				
				)

Argument	Summary
datasource	name of the datasource
type	Type of query to make. Values are: dbnames, tables, columns, version, procedures, foreignkeys, index
dbname	database name [optional]
table	table name [optional]
pattern	pattern to filter results [optional]
username	username for the database [optional]
password	password for the database [optional]

Calling

Supports named-parameter calling allowing you to use the function like:

Dbinfo(
   datasource=?, 
   type=?, 
   dbname=?, 
   table=?, 
   pattern=?, 
   username=?, 
   password=?
);

Supports passing parameters as a structure using ArgumentCollection:

Dbinfo( ArgumentCollection={
   datasource : ?, 
   type : ?, 
   dbname : ?, 
   table : ?, 
   pattern : ?, 
   username : ?, 
   password : ?
} );

Dbinfo()

Usage

Calling

See Also