Find the unique identifier

[guitardave78]

Hey all.
How do I find the unique identifier of a table, I need to know to sort out some dynamic delete stuff

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[gmmastros]

What type of database?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[guitardave78]

It is meant to be as generic as possible.
I have found i can do this using the record set properties so

<code>
for each f in rs.Fields
Response.Write("<td><b>" & f.Name & "</b>")
if f.Properties("KEYCOLUMN") then
response.write("*")
uidColumn = f.Name
tableName = f.Properties("BASETABLENAME")
'uidDataType =
end if
response.write("</td>")
next

</code>

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk