WOLFRAM

Wolfram Language & System Documentation Center

SQLTablePrimaryKeys[conn,table]

returns information about the columns comprising the primary key of table.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLTablePrimaryKeys

SQLTablePrimaryKeys[conn,table]

returns information about the columns comprising the primary key of table.

Details and Options

  • To use SQLTablePrimaryKeys, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
  • "Catalog"Nonedatabase catalog to use
    "Schema"Nonedatabase schema to use
    "ShowColumnHeadings"Falsewhether to return headings with the results

Examples

Basic Examples  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["demo"];

Create a table with a primary key:

Wolfram Language code: SQLCreateTable[conn, SQLTable["PEOPLE"], {SQLColumn["id", "DataTypeName" -> "Integer", "PrimaryKey" -> True], SQLColumn["Name", "DataTypeName" -> "VARCHAR", "DataLength" -> 255], SQLColumn["Age", "DataTypeName" -> "Integer"] }]

Fetch primary key information for this table:

Wolfram Language code: SQLTablePrimaryKeys[conn, "PEOPLE", "ShowColumnHeadings" -> True]//TableForm
Wolfram Language code: SQLDropTable[conn, "PEOPLE"]
Wolfram Language code: CloseSQLConnection[conn];