16.20 - Role Name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24
role_name
Name of the role to drop.
database_name
Containing database for role_name.
user_name
Containing user for role_name.
EXTERNAL
Specifies that the role to be dropped is an external role:
  • For a database role, you cannot specify EXTERNAL.
  • For an external role, you must specify EXTERNAL.

Example: Dropping a Role

This request drops the role named temp_admin.

     DROP ROLE temp_admin;

Example: Dropping an External Role

This request drops the external role named rhh.

     DROP EXTERNAL ROLE rhh;