GNU/Linux |
RedHat 6.2(Zoot) |
|
![]() |
drop_user(l) |
![]() |
DROP USER − Removes an user account information
DROP USER name
INPUTS
name |
The name of an existing user. |
OUTPUTS
DROP |
The message returned if the user is successfully deleted. |
ERROR: removeUser: user "name" does not exist.
This message occurs if the username is not found.
DROP USER removes the specified user from the database, along with any databases owned by the user. It does not remove tables, views, or triggers owned by the named user in databases not owned by the user. This statement can be used in place of the destroyuser script, regardless of how the user was created.
NOTES
DROP USER is a Postgres language extension.
Refer to CREATE USER and ALTER USER for information on how to create or modify user accounts.
To drop a user account:
DROP USER Jonathan;
SQL92
There is no DROP USER in SQL92.
![]() |
drop_user(l) | ![]() |