User Guide

96 The Database API
Description
This function gets a list of all the tables that are defined for the specified database. Each table
object has three properties:
table, schema, and catalog.
Arguments
connName
■ The connName argument is a connection name that is specified in the Connection
Manager. It identifies the connection string that Dreamweaver should use to make a
database connection to a live data source.
Returns
An array of objects where each object has three properties: table, schema, and catalog.
Table is the name of the table. Schema is the name of the schema that contains the table.
Catalog is the catalog that contains the table.
Example
The statement MMDB.getTables ("EmpDB"); might produce an array of two objects. The
first object’s properties might be similar to the following example:
object1[table:"Employees", schema:"personnel", catalog:"syscat"]
The second object’s properties might be similar to the following example:
object2[table:"Departments", schema:"demo", catalog:"syscat2"]
MMDB.getViews()
Availability
Dreamweaver UltraDev 4.
Description
This function gets a list of all the views that are defined for the specified database. Each view
object has
catalog, schema, and view properties.
Arguments
connName
■ The connName argument is a connection name that is specified in the Connection
Manager. It identifies the connection string that Dreamweaver should use to make a
database connection to a live data source.
000_DW_API_Print.book Page 96 Wednesday, July 20, 2005 11:58 AM