Обсуждение: Serial initial and incremental value

Поиск
Список
Период
Сортировка

Serial initial and incremental value

От
"FarjadFarid\(ChkNet\)"
Дата:

Sorry folks,

 

I should have included this in my last question.

 

How can I obtain the initial and incremental value of a serial entity?

 

Many thanks

 

Best Regards

 

Farjad Farid

Re: Serial initial and incremental value

От
Thomas Kellerer
Дата:
FarjadFarid(ChkNet) schrieb am 02.09.2015 um 11:05:
> How can I obtain the initial and incremental value of a serial entity?


You can use:


  select *
  from sequence_name;


where "sequence_name" is the name of the sequence associated with your column.


Thomas