Connection - Maple Programming Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : Connection : Database/Connection/GetSchemas

Connection

  

GetSchemas

  

get a list of schemas from the database

 

Calling Sequence

Parameters

Description

Examples

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.

Examples

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:conn:-GetSchemas

Schema1Schema2Schema3

(1)

conn:-GetSchemas'output'='catalog','name'

Database1Schema1Database1Schema2Database2Schema3

(2)

See Also

Array

Database

Database[Connection]

Database[Connection][GetCatalogs]

Database[Connection][GetColumns]

Database[Connection][GetTables]

Database[Driver]

Database[usage]

 


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam