Show TOC

DROP ROLE Statement (drop_role_statement)Locate this document in the navigation structure

Use

The DROP ROLE statement ( drop_role_statement) deletes a role.

Structure
				
<drop_role_statement>::=
  DROP ROLE <role_name>
				
			

Examples

SQL Tutorial, Roles

Explanation

The current database user must be the owner of the role. The metadata of the role to be dropped is dropped from the database catalog.