How to retrieve the Primary key right after inserting a new record in Sybase?

In Sybase how should we get the Primary key right after inserting a new record? Thank you for the help in advance.

Solution

I assume you talking about an identity column.

Documentation here: Retrieving IDENTITY column values with @@identity

Do I need to declare a unique constraint for `bigint generated always as identity`?
How to retrieve the last autoincremented ID from a SQLite table?
Inserting a row and returning its primary key
Some sort of “different auto-increment indexes” per a primary key values
Is there AUTO INCREMENT in SQLite?
Paging results from a table having a varchar as PK
Difference between primary key and unique key
How to reset Postgres' primary key sequence when it falls out of sync?
Create view with primary key?
How to add an auto-incrementing primary key to an existing table in PostgreSQL?
Primary key effect on performance
Disabling primary key index while inserting
Foreign Key Used in Composite Primary Key
Using Rails, how can I set my primary key to not be an integer-typed column?
Extending IntIdTable in Kotlin Exposed PSQL does not inherit primary key
What is the difference between a primary key and an index key
Django queries when to use "id" vs "pk"?
How do I correctly set the GENERATED BY DEFAULT AS IDENTITY sequence after inserting manual ids?
Insert inserted id to another table
Oracle (ORA-02270) : no matching unique or primary key for this column-list error
spatie/laravel-medialibrary change primary key
How to delete all the entries in the database and reinitialize it completely including the primary keys when reinstalling the app in Android, Room?
Is this the correct way of making primary keys in django?
Postgres and indexes on foreign keys and primary keys
Which constraint is checked first - primary key or unique key (on different columns)?
Back-filling a nullable column with sequence
What is the typical method for preventing duplicates in a PostgreSQL table?
EF Core model unable to create migration due to PrimaryKey referencing a ForeignKey
Updating MySQL primary key
How to generate/autoincrement guid on insert without triggers and manual inserts in mysql?