1 files changed, 8 insertions, 0 deletions
diff --git a/test/sql/test_metadata.py b/test/sql/test_metadata.py
index 38255f977..6d93cb234 100644
--- a/test/sql/test_metadata.py
+++ b/test/sql/test_metadata.py
@@ -2621,9 +2621,17 @@ class SchemaTest(fixtures.TestBase, AssertsCompiledSQL):
             schema.CreateSchema("sa_schema"), "CREATE SCHEMA sa_schema"
         )
         self.assert_compile(
+            schema.CreateSchema("sa_schema", if_not_exists=True),
+            "CREATE SCHEMA IF NOT EXISTS sa_schema",
+        )
+        self.assert_compile(
             schema.DropSchema("sa_schema"), "DROP SCHEMA sa_schema"
         )
         self.assert_compile(
+            schema.DropSchema("sa_schema", if_exists=True),
+            "DROP SCHEMA IF EXISTS sa_schema",
+        )
+        self.assert_compile(
             schema.DropSchema("sa_schema", cascade=True),
             "DROP SCHEMA sa_schema CASCADE",
         )