dictionary:index
This is an old revision of the document!
Table of Contents
The Data Dictionary
Introduction
The Data Dictionary provides a series of functions 'Meta-Functions' that allow a portable method of managing the schema of databases, from simple querying of data attributes of columns to XML based routines to build and manage new tables.
Portable Data Types
The Meta Functions
Metadata functions convert database specific table, column and index queries into a standardized cross-database format.
| metaColumns() | Returns a list of available columns and column type information for the supplied table name |
| metaColumnNames() | Returns a list of available columns for the supplied table name |
| metaDatabases() | Returns a list of available databases |
| metaForeignKeys() | Returns a list of foreign keys for the supplied table name |
| metaIndexes() | Returns a list of indexes for the supplied table name |
| metaPrimaryKeys() | Returns a list of primary keys for the supplied table name |
| metaProcedures() | Returns a list of procedures and functions for the connected database |
| metaTables() | Returns list of available tables for the supplied database name |
| metaType() | Converts database-specific data type into a portable type |
| serverInfo() | Returns a set of server information |
Managing Tables And Columns
Managing Indexes
XML Driven Functions
dictionary/index.1439337370.txt.gz ยท Last modified: 2017/04/21 11:19 (external edit)