Re: determine whether a field is identity column

cutecode wrote:

how to determine whether a field is identity column using ADO?

Thanks

Using the SQLOLEDB provider, you would check the Field object's Attributes
property
http://msdn.microsoft.com/library/en-us/ado270/htm/mdproattributes.asp

to see if it contains the adFldRowID value:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdcstfieldattributeenum.asp

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

.

Relevant Pages

Re: very weird access/ASP error
... you are kicked out of your home that you spent so many years paying for. ... If my wife betrayed me like ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
(microsoft.public.inetserver.asp.db)
Re: Date Format
... If the difference is showing as described, the OP isn't doing "date" math. ... Jeff Boyce wrote: ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
(microsoft.public.access.queries)
Re: The necessity of Setting Objects to Nothing
... And it doesn't bother me at all that Mr Jones ... is holding his nose in disgust, ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
(microsoft.public.scripting.vbscript)
Re: Date Format
... Public Function ConvIntToDate(ByVal num As Long) As Date ... On Error GoTo Err_Handler ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
(microsoft.public.access.queries)
Re: How do I modify class properties after its been created?
... I needed to delete the previous instances and then I was able to modify ... Set loc = CreateObject ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
(microsoft.public.scripting.vbscript)