ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:metatables

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:dictionary:metatables [2016/01/13 02:06] – ↷ Page moved from dictionary:metatables to v5:dictionary:metatables mnewnhamv5:dictionary:metatables [2025/08/29 14:32] (current) – [metaTables] align parameters dregad
Line 5: Line 5:
   string[] metaTables(   string[] metaTables(
     optional string $tableType=false,     optional string $tableType=false,
-    optional bool $showSchema=false+    optional bool   $showSchema=false,
     optional string $mask=false,     optional string $mask=false,
     optional string $schemaMask=false     optional string $schemaMask=false
Line 13: Line 13:
 ===== Description ===== ===== Description =====
 The function ''metaTables()'' returns a list of tables and views in the currently attached database. The function does not return system tables. The function ''metaTables()'' returns a list of tables and views in the currently attached database. The function does not return system tables.
 +-----------------------------
 +===== Casing =====
 +The table name is returned in the **natural casing** of the database. Case-insensitive matches should be used when matching with table names.
 +
 ===== Parameters ===== ===== Parameters =====
 ==== $tableType ===== ==== $tableType =====
-There are 2 available options to this parameter: 
-^Option^Description^ 
-|TABLES|Only show tables in current schema| 
-|VIEWS|Only show views in current schema| 
  
-** Many databases support 'T' and 'V' as these options **+There are 3 possibles values for this parameter: 
 + 
 +^Value^Description^ 
 +| ''TABLES'' *| Only show tables in current schema   | 
 +| ''VIEWS'' * | Only show views in current schema    | 
 +| false       | Show both tables and views (default) | 
 + 
 +* Many drivers also support ''T'' and ''V'' as these options 
 -------------------------------- --------------------------------
  
Line 33: Line 41:
 </WRAP> </WRAP>
 ==== $mask ==== ==== $mask ====
-This option define a mask for matching tables . For example, setting $mask = 'TMP%' will match all tables that begin with 'TMP'. +This option define a mask for matching tables . For example, setting $mask = 'TMP%' will match all tables that begin with 'TMP'. Pattern matching is done in a manner consistent with the SQL //**LIKE**// syntax
 --------------------------------- ---------------------------------
 <WRAP right important 300px> <WRAP right important 300px>
Line 40: Line 48:
 ==== $schemaMask ==== ==== $schemaMask ====
 This option define a mask for matching schemas . For example, setting $mask = 'SYS%' will match all schemas that begin with 'SYS'.  This option define a mask for matching schemas . For example, setting $mask = 'SYS%' will match all schemas that begin with 'SYS'. 
 +----------------------------------------
 ===== Usage ===== ===== Usage =====
 <code php> <code php>
v5/dictionary/metatables.1452647174.txt.gz · Last modified: (external edit)