June 1, 2004 at 3:38 am
Dear All,
Can anyone tell how SQL Server able to return the current_identity,next_identity,etc., (using identity function) in which system tables it stores the identity numbers?
Does SQL Server has any table like User_sequences in oracle?
Thank you.
Balaji
June 1, 2004 at 4:51 am
Check books on line for....
Andy.
June 1, 2004 at 8:35 pm
Thanks for your reply.
I want to know how SQL server internally handling this number, does they have any system table? (like sysobjects,sysindexes,etc.,)
Balaji
June 2, 2004 at 8:22 am
Why do you want to know? What are you trying to solve / accomplish? Identity values will be generated differently depending on the type of the identity column, e.g. a GUID vs. an integer. As in the case of a GUID, I would think that identity values would be generated on the fly rather than tracked somewhere.
June 2, 2004 at 12:41 pm
Hi Balaji,
Try browsing the details in the syscolumns in your database. There is a column called autoval.
This table stores all the columns in the database.
Bye
M.Ali
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy