DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    12

    finding identity column programatically

    Hi
    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 )

    http://www.4guysfromrolla.com/webtech/101799-1.shtml

    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 ?
    thanks

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Jan 2006
    Posts
    12

    thank you


Similar Threads

  1. IDentity column updation
    By Hariharan in forum Database
    Replies: 3
    Last Post: 05-17-2005, 08:57 AM
  2. Entering data into Identity column through VB6
    By Ashok in forum VB Classic
    Replies: 1
    Last Post: 01-10-2001, 04:18 AM
  3. Removing temporary The IDENTITY from Identity Column
    By Nirit Touboul in forum Database
    Replies: 2
    Last Post: 01-03-2001, 01:04 PM
  4. Finding Identity columns with ADO/ADOX
    By Adam Dawes in forum Database
    Replies: 1
    Last Post: 09-28-2000, 04:24 AM
  5. Finding Identity columns with ADO/ADOX
    By Adam Dawes in forum VB Classic
    Replies: 0
    Last Post: 09-26-2000, 12:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


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


Sponsored Links