finding identity column programatically
I am using the source code here in the link below to get info of an sql server database - however there is one thing i need to know about the columns in each table and that is 'is it an identity?' ( i.e an autonumber if you use access )
I am presuming that somewhere in the objColumns recordset there may be an 'identity' value but cannot seem to find any docs ..
or do i need to use a different type of schema to find wether a column is has a property of identity set to true ?
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
By Hariharan in forum Database
Last Post: 05-17-2005, 09:57 AM
By Ashok in forum VB Classic
Last Post: 01-10-2001, 05:18 AM
By Nirit Touboul in forum Database
Last Post: 01-03-2001, 02:04 PM
By Adam Dawes in forum Database
Last Post: 09-28-2000, 05:24 AM
By Adam Dawes in forum VB Classic
Last Post: 09-26-2000, 01:13 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL