getSchema( )
Topic group Related topics Example
Returns information about a database.
Syntax
<oRef>.getSchema(<item expC>)
<oRef>
The database you want to get information about.
<item expC>
The information to retrieve, which may be one of the following strings (which are not case-sensitive):
|
String |
Information |
|
DATABASES |
A list of all databases aliases |
|
PROCEDURES |
A list of stored procedures defined in the database |
|
TABLES |
A list of all tables in the database |
|
VIEWS |
A list of all views in the database |
Property of
Database
Description
Use getSchema( ) to get a list of all database aliases, or to get information about a specific database. Some databases may not support PROCEDURES or VIEWS. All lists are returned in an Array object; if the item is not supported, the array is empty.
Custom data drivers must define this method to return the appropriate information for their database.