primary key check

[Guest_imported]

Hi All,

We have an interesting question for you.
Is there any way to see if a column pulled from a database in a cfquery is a primary key?

As far as we know ther's no CF function for this.
So a workaround seems to be needed
Any suggestions?

tnx

 

[CFHub]

ICQof188 posted an interesting article on this last month using ADO. (it should be in this archive somwhere).

There is a modified version of that and a few other ADO scripts here as well.

http://cfhub.com/advanced/ado/

If you hunt around the Allaire site, there is a another method that modifies the permissions to the Access sytem tables... I haven't been able to locate it since they updated their forum.

If you are using Oracle or MySQL you may need to find a different workaround.