PostgreSQL

Скачать в pdf «PostgreSQL»


name The name of an existing group.


Outputs


DROP GROUP The message returned if the group is successfully deleted.


Description


DROP GROUP removes the specified group from the database. The users in the group are not deleted.


Use CREATE GROUP to add new groups, and ALTER GROUP to change a group’s membership.


Usage


To drop a group:


DROP GROUP staff;


Compatibility


SQL92


There is no DROP GROUP in SQL92.

d.36 drop index


Name


DROP INDEX — Removes an index from a database DROP INDEX index_name


Inputs


index_name The name of the index to remove.


Outputs


DROP The message returned if the index is successfully dropped.


ERROR: index «index_name » nonexistent This message occurs if index_name is not an index in the database.


Description


DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.


Notes


DROP INDEX is a Postgres language extension.


Refer to CREATE INDEX for information on how to create indexes.


Usage


This command will remove the title_idx index:


DROP INDEX titlejdx;


Compatibility


SQL92


SQL92 defines commands by which to access a generic relational database. Indexes are an implementation-dependent feature and hence there are no index-specific commands or definitions in the SQL92 language.

d.37 drop language


Name


DROP LANGUAGE — Removes a user-defined procedural language DROP PROCEDURAL LANGUAGE ’name

Скачать в pdf «PostgreSQL»