Finding the key fields in SQL database.

Customer Support Database Support
1

I am using the following code to list the fields in a database table. What I need to do though is know which ones are the ‘key’ fields. Can anyone help?
Thanks very much. Nathan

set conntemp=server.createobject(“adodb.connection”)
conntemp.open strCon
set rsTable=conntemp.execute(SQLStr)

for each FieldName in rsTable.fields
  response.write FieldName.Name 
next

rsTable.close
set rsTable=nothing
conntemp.close
set conntemp=nothing

2

try this:

set rsprimarykey = conn.execute("select * from information_schema.table_constraints where (table_name = '" & db & "') AND (constraint_type = 'Primary Key')") set rsprimarykey2 = conn.execute("select column_name from information_schema.key_column_usage where (constraint_name = '" & rsprimarykey("constraint_name") & "')") primarykey = rsprimarykey2("column_name")

[QUOTE=Nathan]
I am using the following code to list the fields in a database table. What I need to do though is know which ones are the ‘key’ fields. Can anyone help?
Thanks very much. Nathan

set conntemp=server.createobject(“adodb.connection”)
conntemp.open strCon
set rsTable=conntemp.execute(SQLStr)

for each FieldName in rsTable.fields
  response.write FieldName.Name 
next

rsTable.close
set rsTable=nothing
conntemp.close
set conntemp=nothing
[/QUOTE]

3

Hmmm…not that well up on Access/Jet. Maybe you could try a Google search “How to list Primary Key fields in Access” or something?

4

That’s great - thanks “jonyah” It is exactly what we needed. With help from a mate Sofri, we now have the system working exactly as we wanted.

Again, thanks very much, pop down anytime to the taverna for a well deserved beer from me!

Nathan

www.agni.gr

5

np, just trying to give back what I can.

[QUOTE=Nathan]
That’s great - thanks “jonyah” It is exactly what we needed. With help from a mate Sofri, we now have the system working exactly as we wanted.

Again, thanks very much, pop down anytime to the taverna for a well deserved beer from me!

Nathan

www.agni.gr
[/QUOTE]