v5:userguide:learn_dictionary:other_metafunctions
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:userguide:learn_dictionary:other_metafunctions [2016/03/17 00:15] – ↷ Page name changed from v5:userguide:learn_dictionary:metatables to v5:userguide:learn_dictionary:other_metafunctions mnewnham | v5:userguide:learn_dictionary:other_metafunctions [2018/06/11 10:09] (current) – function names starting with lowercase (#426) dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <- v5: | + | <- v5: |
~~NOTOC~~ | ~~NOTOC~~ | ||
- | ====== MetaTables ====== | ||
- | The method [[v5: | ||
- | + | ====== Other MetaFunctions ====== | |
+ | |||
+ | ===== metaTables() ===== | ||
+ | |||
+ | The method [[v5: | ||
+ | <code php> | ||
+ | $ar = $db-> | ||
+ | /* | ||
+ | * $ar returns: | ||
+ | [0] => DEPT | ||
+ | [1] => EMP | ||
+ | [2] => EMPACT | ||
+ | [3] => EMP_ACT | ||
+ | [4] => PROJ | ||
+ | [5] => ADEFUSR | ||
+ | ...... | ||
+ | </ | ||
+ | |||
+ | ===== metaIndexes() ===== | ||
+ | |||
+ | The method [[v5: | ||
+ | <code php> | ||
+ | print_r($db-> | ||
+ | |||
+ | /* | ||
+ | * Prints | ||
+ | Array( | ||
+ | [index_name] => Array | ||
+ | ( | ||
+ | [unique] => 0 | ||
+ | [columns] => Array | ||
+ | ( | ||
+ | [0] => Column 1 | ||
+ | [1] => Column 2 | ||
+ | [2] => etc........ | ||
+ | ) | ||
+ | |||
+ | ) | ||
+ | */ | ||
+ | </ | ||
+ | |||
+ | ===== metaPrimaryKeys() ===== | ||
+ | |||
+ | The [[v5: | ||
+ | <code php> | ||
+ | $mpk = $db-> | ||
+ | print_r($mpk); | ||
+ | /* | ||
+ | * Prints | ||
+ | Array | ||
+ | ( | ||
+ | [0] => ACTNO | ||
+ | ) | ||
+ | |||
+ | */ | ||
+ | </ | ||
+ | |||
+ | ===== metaProcedures() ===== | ||
+ | |||
+ | The method [[v5: | ||
+ | ------------------------------------------- | ||
+ | Array( | ||
+ | [name_of_procedure] => Array( | ||
+ | [type] => PROCEDURE or FUNCTION or METHOD | ||
+ | [catalog] => Catalog (or owner) name | ||
+ | [schema] => Schema name | ||
+ | [remarks] => explanatory comment on the procedure | ||
+ | ) | ||
+ | ) | ||
+ | |||
+ | ===== metaForeignKeys() ===== | ||
+ | |||
+ | The [[v5: | ||
+ | <code php> | ||
+ | $p = $db-> | ||
+ | print_r($p); | ||
+ | /* | ||
+ | * prints | ||
+ | Array | ||
+ | ( | ||
+ | [employees] => Array | ||
+ | ( | ||
+ | [0] => emp_no=emp_no | ||
+ | ) | ||
+ | |||
+ | [departments] => Array | ||
+ | ( | ||
+ | [0] => dept_no=dept_no | ||
+ | ) | ||
+ | |||
+ | ) | ||
+ | */ | ||
+ | </ | ||
+ | |||
+ | |||
+ | <WRAP info 300px center> | ||
+ | **End Of Lesson** | ||
+ | </ |
v5/userguide/learn_dictionary/other_metafunctions.1458170110.txt.gz · Last modified: 2017/04/21 11:40 (external edit)