ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:learn_dictionary:other_metafunctions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:userguide:learn_dictionary:other_metafunctions [2016/03/17 00:51] – mnewnhamv5:userguide:learn_dictionary:other_metafunctions [2018/06/11 10:09] (current) – function names starting with lowercase (#426) dregad
Line 1: Line 1:
 <- v5:userguide:learn_dictionary:metacolumns:|MetaColumns ^ v5:userguide:learn_dictionary:start_lesson|Start Of Lesson ^  -> <- v5:userguide:learn_dictionary:metacolumns:|MetaColumns ^ v5:userguide:learn_dictionary:start_lesson|Start Of Lesson ^  ->
 ~~NOTOC~~ ~~NOTOC~~
-====== MetaTables ======+ 
 +====== Other MetaFunctions ====== 
 + 
 +===== metaTables() ===== 
 The method [[v5:dictionary:metatables|metaTables()]] returns a list of the tables in the database. In some databases, the values returned by the method may be restricted based on built-in security in the DBMS. The method [[v5:dictionary:metatables|metaTables()]] returns a list of the tables in the database. In some databases, the values returned by the method may be restricted based on built-in security in the DBMS.
 <code php> <code php>
Line 15: Line 19:
   ......   ......
 </code> </code>
-===== MetaIndexes =====+ 
 +===== metaIndexes() ===== 
 The method [[v5:dictionary:metaindexes|metaIndexes()]] returns an array of data containing index information about a requested table The method [[v5:dictionary:metaindexes|metaIndexes()]] returns an array of data containing index information about a requested table
 <code php> <code php>
Line 37: Line 43:
 </code> </code>
  
-===== MetaPrimaryKeys ===== +===== metaPrimaryKeys() ===== 
-The [[v5:dictionary:metaprimarykeys|metaPrimaryKeys()]] method returns a list of Primary Keys associated with a + 
 +The [[v5:dictionary:metaprimarykeys|metaPrimaryKeys()]] method returns a list of Primary Keys associated with a table
 <code php> <code php>
 $mpk = $db->metaPrimaryKeys('ACT'); $mpk = $db->metaPrimaryKeys('ACT');
Line 52: Line 59:
 </code> </code>
  
-===== MetaProcedures =====+===== metaProcedures() ===== 
 The method [[v5:dictionary:metaprocedures|metaProcedures()]] returns a list of stored procedures in a database. Some databases do not support stored procedures. The format of the data returned is as follows: The method [[v5:dictionary:metaprocedures|metaProcedures()]] returns a list of stored procedures in a database. Some databases do not support stored procedures. The format of the data returned is as follows:
 -------------------------------------------  ------------------------------------------- 
Line 64: Line 72:
   )   )
  
-===== MetaForeignKeys =====+===== metaForeignKeys() ===== 
 The [[v5:dictionary:metaforeignkeys|metaForeignKeys()]] method returns a list of [[WP>foreign key|Foreign Keys]]  (sometimes called **//Constraints//**) associated with a requested table. Each array entry shows the foreign table, and the fields that are related. The [[v5:dictionary:metaforeignkeys|metaForeignKeys()]] method returns a list of [[WP>foreign key|Foreign Keys]]  (sometimes called **//Constraints//**) associated with a requested table. Each array entry shows the foreign table, and the fields that are related.
 <code php> <code php>
Line 89: Line 98:
  
 <WRAP info 300px center> <WRAP info 300px center>
-**End Of Lesson 2**+**End Of Lesson**
 </WRAP> </WRAP>
v5/userguide/learn_dictionary/other_metafunctions.1458172279.txt.gz · Last modified: 2017/04/21 11:40 (external edit)