DROP VIEW

Function

DROP VIEW deletes a view with a specified name from LakeFormation.

Syntax

1

DROP VIEW [IF EXISTS] view_name;

Parameter Description

• IF EXISTS

  If the specified view does not exist, a message is displayed without any error message.

• view_name

  Name of the LakeFormation view.

Examples

Delete the test_view view, but do not delete the tables on which the view depends.

1

DROP VIEW test_view;