====== metaTables =====
~~NOTOC~~
<WRAP right box>
== Syntax == 
  string[] metaTables(
    optional string $tableType=false,
    optional bool   $showSchema=false,
    optional string $mask=false,
    optional string $schemaMask=false
    )
  
</WRAP>
===== Description =====
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 =====
==== $tableType =====

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

--------------------------------

<WRAP right important 300px>
Support for this option is limited to the IBM DB2 driver
</WRAP>
==== $showSchema ====
This parameter attaches the schema name to the table
---------------------------------
<WRAP right important 300px>
Support for this option is limited. Check the database driver documentation.
</WRAP>
==== $mask ====
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>
Support for this option is limited to the deprecated ODBC driver for IBM and may be removed in future releases . Check the database driver documentation.
</WRAP>
==== $schemaMask ====
This option define a mask for matching schemas . For example, setting $mask = 'SYS%' will match all schemas that begin with 'SYS'. 
----------------------------------------
===== Usage =====
<code php>
/*
 * Assume connection to DB2 database 'sample'
 */

$ar = $db->metaTables('TABLES');
/*
 * $ar returns:
  [0] => DEPT
  [1] => EMP
  [2] => EMPACT
  [3] => EMP_ACT
  [4] => PROJ
  [5] => ADEFUSR
  ......
</code>