How do i determine what the next value is of the Primary Key Auto increment?
I have been looking in the system databases but i couldnt find any answers.
Asked
Active
Viewed 995 times
-1
-
Select and Order by that column, descending, limit 1, then add one to the result? – OneCricketeer Nov 08 '18 at 05:01
-
That is exactly what i have done, i used `MAX()` function. Does the index from the primary key also change after this? – Wvs Nov 08 '18 at 14:16
-
I don't know Sybase, but no values of any technology should be changing as part of a read/select operation – OneCricketeer Nov 08 '18 at 15:04
1 Answers
1
I am guessing you mean "the next value to be assigned to an identity column", and your identity column also happens to be used as a primary key. Otherwise, there is no concept in Sybase ASE that would qualify as "Primary Key Auto increment".
Assuming the above, you can get the next value to be assigned by using the function next_identity('table_name'). Note that the result is in varchar format so you may need to convert it back to a number.
RobV
- 2,263
- 1
- 11
- 7
-
Thanks Rob! When i do `SELECT next_identity('tablename')` it returns (NULL) also when i try to CAST it to int it returns `NULL` Any ideas? – Wvs Nov 09 '18 at 14:07
-
That means your table does not actually have an identity column. Check with sp_help. – RobV Nov 11 '18 at 10:38