How to I detect Identity column in SQL SERVER 2000 by using VB6 and ADOX object.??

I don't think you can.

ADOX is a generic mechanism for database schema manipulation. As such, it is made to operate with a variety of providers, most of which don't have an IDENTITY attribute (e.g Oracle and JET).

It may be a provider-specific property of the OLEDB for SQL Server provider, but I couldn't find any mention of it in any documentation I had.

You might try the SQL-DMO objects as an alternative. That does expose an explicit identity property of a (table) column object.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for your information. I want to know more about SQL-DMO Object. Thanks in advance.

Look in BOL index for 'SQL-DMO'. There is an extensive and detailed discussion of the SQL Server Distributed Management Objects. Anything you can do in EM, you can do with SQL-DMO.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com