aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pgaccess/lib/help/drop_sequence.hlp
blob: 7b2a16c14e721d09eb1b208650dc6bca535320b2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
.pgaw:Help.f.t insert end "DROP SEQUENCE" {bold} " removes sequence number generators from the data base. With the current implementation of sequences as special tables it works just like the DROP TABLE statement.

" {} "Synopsis" {bold} "
" {} "
DROP SEQUENCE seqname \[, ...\]

" {code} "Usage" {bold} "

To remove sequence serial from database: 

DROP SEQUENCE serial
  
" {} "Notes" {bold} "

The DROP SEQUENCE statement is a Postgres language extension. 

Refer to the CREATE SEQUENCE statement for information on how to create a sequence. "