#1 30 Sep 2008 18:27

luck91
Member
Registered: 30 Sep 2008
Posts: 1

hibernate_sequence

Can someone give me a laymen explanation of what these two lines do:


drop sequence hibernate_sequence;

create sequence hibernate_sequence;

Offline

#2 01 Oct 2008 12:28

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 899
Website

Re: hibernate_sequence

It will reset the value of the sequence back to 1

drop sequence - removes the existing sequence along with it's current value

create sequence with no options specified - will create an ascending sequence starting at the number 1

Offline

#3 02 Oct 2008 06:48

rajeshmoktan
Member
Registered: 02 Oct 2008
Posts: 1

Re: hibernate_sequence

luck91 wrote:

Can someone give me a laymen explanation of what these two lines do:


drop sequence hibernate_sequence;

create sequence hibernate_sequence;

Sequesce is the built in couter created by the database for a record in the table:pc:

Offline

Board footer

Powered by FluxBB