Removes a user-defined profile (created by
CREATE PROFILE) from the database. You cannot drop the
DROP PROFILE [ IF EXISTS ] profile‑name[,…] [ CASCADE ]
Specifies not to report an error if the profile to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
The profile to drop.
Moves all users assigned to the dropped profiles to the DEFAULT profile. If you omit this option and a targeted profile has users assigned to it, Vertica returns an error.
=> DROP PROFILE sample_profile;