Maple Professional
Maple Academic
Maple Student Edition
Maple Personal Edition
Maple Player
Maple Player for iPad
MapleSim Professional
MapleSim Academic
Maple T.A. - Testing & Assessment
Maple T.A. MAA Placement Test Suite
Möbius - Online Courseware
Machine Design / Industrial Automation
Aerospace
Vehicle Engineering
Robotics
Power Industries
System Simulation and Analysis
Model development for HIL
Plant Modeling for Control Design
Robotics/Motion Control/Mechatronics
Other Application Areas
Mathematics Education
Engineering Education
High Schools & Two-Year Colleges
Testing & Assessment
Students
Financial Modeling
Operations Research
High Performance Computing
Physics
Live Webinars
Recorded Webinars
Upcoming Events
MaplePrimes
Maplesoft Blog
Maplesoft Membership
Maple Ambassador Program
MapleCloud
Technical Whitepapers
E-Mail Newsletters
Maple Books
Math Matters
Application Center
MapleSim Model Gallery
User Case Studies
Exploring Engineering Fundamentals
Teaching Concepts with Maple
Maplesoft Welcome Center
Teacher Resource Center
Student Help Center
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.
Examples
See Also
Array, Database, Database[Connection], Database[Connection][GetCatalogs], Database[Connection][GetColumns], Database[Connection][GetTables], Database[Driver], Database[usage]
Download Help Document