![]() To execute the DROP SCHEMA statement, you must be the owner of the schema that you want to drop or a superuser. By default, the DROP SCHEMA uses the RESTRICT option. If you want to delete schema only when it is empty, you can use the RESTRICT option. ![]() Third, use CASCADE to delete schema and all of its objects, and in turn, all objects that depend on those objects.Second, use the IF EXISTS option to conditionally delete schema only if it exists.First, specify the name of the schema from which you want to remove after the DROP SCHEMA keywords.The following illustrates the syntax of the DROP SCHEMA statement: DROP SCHEMA schema_name Code language: CSS ( css ) The DROP SCHEMA removes a schema and all of its objects from a database. PostgreSQL DROP SCHEMA statement overview Summary: in this tutorial, you will learn how to use the PostgreSQL DROP SCHEMA statement to delete a schema and its objects.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |