PHP 8.1.0 RC 2 available for testing

odbc_primarykeys

(PHP 4, PHP 5, PHP 7)

odbc_primarykeysGets the primary keys for a table

Descrierea

odbc_primarykeys ( resource $odbc , string|null $catalog , string $schema , string $table ) : resource|false

Returns a result identifier that can be used to fetch the column names that comprise the primary key for a table.

Parametri

odbc

Identificatorul conexiunii ODBC, accesați odbc_connect() pentru detalii.

catalog

Catalogul ('calificativul' în jargonul ODBC 2).

schema

Schema ('proprietarul' în jargonul ODBC 2).

table

Valorile întoarse

Returns an ODBC result identifier sau false în cazul eșecului.

The result set has the following columns:

  • TABLE_CAT
  • TABLE_SCHEM
  • TABLE_NAME
  • COLUMN_NAME
  • KEY_SEQ
  • PK_NAME
Driver-ele pot raporta coloane suplimentare.

The result set is ordered by TABLE_CAT, TABLE_SCHEM, TABLE_NAME and KEY_SEQ.

Exemple

Example #1 List primary Keys of a Column

<?php
$conn 
odbc_connect($dsn$user$pass);
$primarykeys odbc_primarykeys($conn'TutorialDB''dbo''TEST');
while ((
$row odbc_fetch_array($primarykeys))) {
    
print_r($row);
    break; 
// further rows omitted for brevity
}
?>

Exemplul de mai sus va afișa ceva similar cu:

Array
(
    [TABLE_CAT] => TutorialDB
    [TABLE_SCHEM] => dbo
    [TABLE_NAME] => TEST
    [COLUMN_NAME] => id
    [KEY_SEQ] => 1
    [PK_NAME] => PK__TEST__3213E83FE141F843
)

A se vedea și

add a note add a note

User Contributed Notes 4 notes

up
1
Rio Bautista (RRIT)
17 years ago
Sample to get the primary keys of an MSSQL table:

$cn = odbc_connect( "DSN", "sa", "pwd");

$rs = odbc_primarykeys( $cn, "database", "dbo", "table_name");

odbc_result_all($rs);
up
0
dan dot scott at ca dot ibm dot com
16 years ago
Responding to devendra_joshi:

In DB2 Universal Database for Linux, UNIX, and Windows the catalog views are accessed through the SYSCAT schema, not the SYSIBM schema -- so you should be issuing "SELECT * FROM SYSCAT.KEYCOLUSE" to list all of the columns that participate in a given key constraint.

A complete list of the catalog views for DB2 can be referenced at http://publib.boulder.ibm.com/infocenter/db2help/ by searching for 'catalog views' and selecting the top hit.
up
0
devendra_joshi at hotmail dot com
18 years ago
I want a list of primary keys of a table in db2

by using
'select * from SYSIBM.SYSKEYCOLUSE ' query i am getting the result on CLP
but when i am writing it in PHP as follows it returns 0 ROWS.

$mstmt="select * from SYSIBM.SYSKEYCOLUSE";
$b=odbc_exec($conn,$mstmt);
echo odbc_result_all($b);

where as  if we write this code

$mstmt="select * from SYSIBM.SYSFUNCTIONS";
$b=odbc_exec($conn,$mstmt);
echo odbc_result_all($b);

it returns the correct data.
up
-2
ewilde aht bsmdevelopment dawt com
15 years ago
I was trying to find the primary keys from an SQLServer database through the ODBC interface.  Funnily enough, the odbc_primarykeys function doesn't work with SQLServer (at least not my implementation of it).  Fortunately, the sp_keys query is passed through and the answer returned.  This code works (providing you know which database you're dealing with, which is a whole 'nother story).

// If this is SQLServer, we need to do a special operation to get the
// primary keys.
//
// Looks like the implementers of the ODBC interface just blew this
// one off, since the database has a query to return the info and the
// info even comes back with the same column names.
if ($DBType == "SQLServer")
  $KeySel = odbc_exec($DBConn, "sp_pkeys ".$TableName);

// Otherwise, ask the database through ODBC for the primary key
// names.
else $KeySel = odbc_primarykeys($DBConn, $DatabaseName,
  $DatabaseUser, $TableName);

while ($KeySel && ($KeyRec = odbc_fetch_array($KeySel)))
  $KeyCol[$KeyRec["KEY_SEQ"]] = $KeyRec["COLUMN_NAME"];
To Top