IDENT_CURRENT

IDENT_CURRENT#

Not supported. IDENT_CURRENT always raises an error: its result is the live identity counter on the backing data source, and Querona has no mechanism to read that counter at query-evaluation time. Use SCOPE_IDENTITY instead.

Syntax#

IDENT_CURRENT ( 'table' )

Arguments#

table

The name of the table, as a string.

Example#

SELECT IDENT_CURRENT('dbo.Product');
-- Error: IDENT_CURRENT is not supported: its value is the live identity counter on the
-- backing source, which the Engine cannot honor from metadata.

See Also#