db2_tables

(PECL ibm_db2 >= 1.0.0)

db2_tables — Returns a result set listing the tables and associated metadata in a database

说明

db2_tables(
    resource $connection,
    string $qualifier = ?,
    string $schema = ?,
    string $table-name = ?,
    string $table-type = ?
): resource

Returns a result set listing the tables and associated metadata in a database.

参数

connection: A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
qualifier: A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass null or an empty string.
schema: The schema which contains the tables. This parameter accepts a search pattern containing _ and % as wildcards.
table-name: The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.
table-type: A list of comma-delimited table type identifiers. To match all table types, pass null or an empty string. Valid table type identifiers include: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE, TYPED VIEW, and VIEW.

返回值

Returns a statement resource with a result set containing rows describing the tables that match the specified parameters. The rows are composed of the following columns:

Column name	Description
TABLE_CAT	The catalog that contains the table. The value is `null` if this table does not have catalogs.
TABLE_SCHEM	Name of the schema that contains the table.
TABLE_NAME	Name of the table.
TABLE_TYPE	Table type identifier for the table.
REMARKS	Description of the table.

参见

db2_column_privileges() - Returns a result set listing the columns and associated privileges for a table
db2_columns() - Returns a result set listing the columns and associated metadata for a table
db2_foreign_keys() - Returns a result set listing the foreign keys for a table
db2_primary_keys() - Returns a result set listing primary keys for a table
db2_procedure_columns() - Returns a result set listing stored procedure parameters
db2_procedures() - Returns a result set listing the stored procedures registered in a database
db2_special_columns() - Returns a result set listing the unique row identifier columns for a table
db2_statistics() - Returns a result set listing the index and statistics for a table
db2_table_privileges() - Returns a result set listing the tables and associated privileges in a database

add a note

User Contributed Notes

There are no user contributed notes for this page.

官方地址：https://www.php.net/manual/en/function.db2-tables.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 adodb手册 PHP 8.1 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 Composer的Packagist资源 mysql面试题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 PHP7添加redis扩展 PHP获取指定函数定义在哪个文件中及行号 PHP mkdir()写出来的权限与mode值不符合 adodb连接mysql多个数据库的问题利用php soap实现web service 利用PHP SOAP实现WEB SERVICE

略微加速

PHP官方手册 - 互联网笔记

db2_tables

说明

参数

返回值

参见

User Contributed Notes