Connection:-GetSchemas - get a list of schemas from the database
|
Calling Sequence
|
|
connection:-GetSchemas( opts )
|
|
Parameters
|
|
connection
|
-
|
Connection module
|
opts
|
-
|
(optional) equation of the form output=value
|
|
|
|
|
Description
|
|
•
|
GetSchemas returns an Array in which each row of the Array contains matches from one schema in the database connected to using connection. A column in the Array is data associated with the table. The output option controls the columns and their order in the returned Array.
|
•
|
A schema in a database is similar to a namespace. Objects that use different schema and have the same name are distinct.
|
•
|
The opts argument can contain the following equation.
|
|
output = list containing one or both literal symbols name and catalog
|
|
The output option specifies the columns of information to return and their order. By default, only the name is returned.
|
|
- name returns the name of the schema.
|
|
- catalog returns the name of the catalog that uses the schema.
|
|
|
Download Help Document
Was this information helpful?