finding identity column programatically


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: finding identity column programatically

  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

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


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center