Identity Column

[pgthyagu]

Is there a way to get the Current Identity Value of a table from any System Table ?i.e an SQL Query to get the Current Identity Value. I Don;t want to use the Functions given in SQL.

If it is not stored in the System Table how is this maintained.

Regards

Thyagu

 

[AWithers]

I dont know how it is stored but a simple way of getting the next value to be used(assuming that the identity field is incremental with a increment of 1) would be to

select max(youridentfield) +1 as nextidentity from yourtable

Andy