aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pgaccess/lib/help/drop_index.hlp
blob: 1b53db3137a30df101d64ecd30c6b56f934b39ca (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 INDEX" {bold} " drops an existing index from the database system. To execute this command you must be the owner of the index. 

" {} "Synopsis" {bold} "

DROP INDEX index_name

" {code} "Usage" {bold} "

This command will remove the title_idx index: 
" {} "
DROP INDEX title_idx;
  
" {code} "Notes" {bold} "

DROP INDEX is a Postgres language extension. 

Refer to the CREATE INDEX statement for information on how to create indexes. "