Get the name of the primary key

  • Thread starter Thread starter Patrick B
  • Start date Start date
P

Patrick B

Working with a Microsoft Access database, what is the best way to get
the name of the primary key field? I know the table name.
 
You can use the datareader as follows:

Dim cn as New OleDbConnection(strConnectString)
Dim cmd as New OleDbCommand
Dim myReader as OleDbDataReader
Dim dt as DataTable
Dim dRow as DataRow
Dim strPrimaryKeyList as String

cn.Open()
cmd.Connection = cn
cmd.CommandText = "Select * From yourTable"
myReader = cmd.ExecuteReader(CommandBehavior.KeyInfo)
dt = myReader.GetSchemaTable()
strPrimaryKeyList = ""
For Each dRow in dt.Rows
If dRow("IsKey") then
strPrimaryKeyList += dRow("ColumnName") & vbcrlf
End If
Next
cn.Close()

When done strPrimaryKeyList holds a list of the primary key field
names.

Hope that helps,
John
(PS I typed this in adHoc so check for typos, but you should get the
idea)
 
Back
Top