phpstudy所有软件,已经通过360安全检测认证,phpstudy linux web面板(docker),已发布安全检测与修复

odbc_foreignkeys

odbc_foreignkeys

(PHP 4, PHP 5)

odbc_foreignkeysRetrieves a list of foreign keys

说明

resource odbc_foreignkeys ( resource $connection_id , string $pk_qualifier , string $pk_owner , string $pk_table , string $fk_qualifier , string $fk_owner , string $fk_table )

Retrieves a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the specified table

参数

connection_id

ODBC 连接标识符,详见 odbc_connect()

pk_qualifier

The primary key qualifier.

pk_owner

The primary key owner.

pk_table

The primary key table.

fk_qualifier

The foreign key qualifier.

fk_owner

The foreign key owner.

fk_table

The foreign key table.

返回值

Returns an ODBC result identifier 或者在失败时返回 FALSE.

The result set has the following columns:

  • PKTABLE_QUALIFIER
  • PKTABLE_OWNER
  • PKTABLE_NAME
  • PKCOLUMN_NAME
  • FKTABLE_QUALIFIER
  • FKTABLE_OWNER
  • FKTABLE_NAME
  • FKCOLUMN_NAME
  • KEY_SEQ
  • UPDATE_RULE
  • DELETE_RULE
  • FK_NAME
  • PK_NAME

If pk_table contains a table name, odbc_foreignkeys() returns a result set containing the primary key of the specified table and all of the foreign keys that refer to it.

If fk_table contains a table name, odbc_foreignkeys() returns a result set containing all of the foreign keys in the specified table and the primary keys (in other tables) to which they refer.

If both pk_table and fk_table contain table names, odbc_foreignkeys() returns the foreign keys in the table specified in fk_table that refer to the primary key of the table specified in pk_table. This should be one key at most.


  • odbc_autocommit
  • odbc_binmode
  • odbc_close
  • odbc_close_all
  • odbc_columnprivileges
  • odbc_columns
  • odbc_commit
  • odbc_connect
  • odbc_cursor
  • odbc_data_source
  • odbc_do
  • odbc_error
  • odbc_errormsg
  • odbc_exec
  • odbc_execute
  • odbc_fetch_array
  • odbc_fetch_into
  • odbc_fetch_object
  • odbc_fetch_row
  • odbc_field_len
  • odbc_field_name
  • odbc_field_num
  • odbc_field_precision
  • odbc_field_scale
  • odbc_field_type
  • odbc_foreignkeys
  • odbc_free_result
  • odbc_gettypeinfo
  • odbc_longreadlen
  • odbc_next_result
  • odbc_num_fields
  • odbc_num_rows
  • odbc_pconnect
  • odbc_prepare
  • odbc_primarykeys
  • odbc_procedurecolumns
  • odbc_procedures
  • odbc_result
  • odbc_result_all
  • odbc_rollback
  • odbc_setoption
  • odbc_specialcolumns
  • odbc_statistics
  • odbc_tableprivileges
  • odbc_tables
  • PHP MySQL HTML CSS JavaScript MSSQL AJAX .NET JSP Linux Mac ASP 服务器 SQL jQuery C# C++ java Android IOS oracle MongoDB SQLite wamp 交通频道

    微信扫码登陆

    打开 微信
    扫一扫登录