Re: How to reset Sequence values ?

From: Honza Pazdziora <adelton_at_fi.muni.cz>
Date: Tue, 30 Jan 2001 09:16:21 GMT
Message-ID: <G7yxr9.9zs@news.muni.cz>

On Tue, 30 Jan 2001 08:57:13 GMT, mohammad_amer_at_my-deja.com <mohammad_amer_at_my-deja.com> wrote:

> why kari does he have to re-create the sequences?

The best answer would be: because.

> he can alter them..

Yes but not to change the current value. From 8.1.7 documentation:

	To restart the sequence at a different number, you must drop
	and re-create it.

Yours,

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton@fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
Petition for a Software Patent Free Europe http://petition.eurolinux.org
------------------------------------------------------------------------

Received on Tue Jan 30 2001 - 03:16:21 CST