Making a rapid search I found this link, it could help you http://blogs.msdn.com/sqltips/archive/2005/09/16/469136.aspx
Greetings -----Original Message----- From: John Stottlemire [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 11:56 PM To: CF-Talk Subject: Re: MS Access Primary Key Come on, someone has to know how to do this > Anyone know of a way to find the Primary Key in a table using CFMX and > SQL? > > I know that queryname.columnlist returns the field names, but I'm > trying to determine the primary key of the database table as well. > > Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

