# phpman > man > DROP_POLICY(7)

DROP [POLICY(7)](https://www.chedong.com/phpMan.php/man/POLICY/7/markdown)                     PostgreSQL 14.23 Documentation                     DROP [POLICY(7)](https://www.chedong.com/phpMan.php/man/POLICY/7/markdown)



## NAME
       DROP_POLICY - remove a row-level security policy from a table

## SYNOPSIS
       DROP POLICY [ IF EXISTS ] _name_ ON _table_name_ [ CASCADE | RESTRICT ]

## DESCRIPTION
       **DROP** **POLICY** removes the specified policy from the table. Note that if the last policy is
       removed for a table and the table still has row-level security enabled via **ALTER** **TABLE**, then
       the default-deny policy will be used.  ALTER TABLE ... DISABLE ROW LEVEL SECURITY can be used
       to disable row-level security for a table, whether policies for the table exist or not.

## PARAMETERS
       IF EXISTS
           Do not throw an error if the policy does not exist. A notice is issued in this case.

       _name_
           The name of the policy to drop.

       _table_name_
           The name (optionally schema-qualified) of the table that the policy is on.

       CASCADE
       RESTRICT
           These key words do not have any effect, since there are no dependencies on policies.

## EXAMPLES
       To drop the policy called p1 on the table named my_table:

           DROP POLICY p1 ON my_table;

## COMPATIBILITY
       **DROP** **POLICY** is a PostgreSQL extension.

## SEE ALSO
       CREATE POLICY (**CREATE**___**[POLICY**(7)](https://www.chedong.com/phpMan.php/man/POLICY/7/markdown)), ALTER POLICY (**ALTER**___**[POLICY**(7)](https://www.chedong.com/phpMan.php/man/POLICY/7/markdown))



PostgreSQL 14.23                                2026                                  DROP [POLICY(7)](https://www.chedong.com/phpMan.php/man/POLICY/7/markdown)