DROP POLICY

The DROP POLICY statement removes an existing row-level security (RLS) policy from a table.

Syntax

DROP POLICY [ IF EXISTS ] policy_name ON table_name [ CASCADE | RESTRICT ];

Parameter	Description
`policy_name`	Unique identifier for the policy on the table.
`table_name`	The table to which the policy applies.
`IF EXISTS`	Suppresses an error if the policy doesn’t exist.
`CASCADE, RESTRICT`	Standard dependency handling (not relevant for policies themselves).

To drop an existing policy, issue the following statement:

DROP POLICY IF EXISTS your_policy ON orders;