1 files changed, 10 insertions, 0 deletions
diff --git a/test/sql/test_sequences.py b/test/sql/test_sequences.py
index 19f95c661..457aeb960 100644
--- a/test/sql/test_sequences.py
+++ b/test/sql/test_sequences.py
@@ -93,9 +93,19 @@ class SequenceDDLTest(fixtures.TestBase, testing.AssertsCompiledSQL):
         )
 
         self.assert_compile(
+            CreateSequence(Sequence("foo_seq"), if_not_exists=True),
+            "CREATE SEQUENCE IF NOT EXISTS foo_seq START WITH 1",
+        )
+
+        self.assert_compile(
             DropSequence(Sequence("foo_seq")), "DROP SEQUENCE foo_seq"
         )
 
+        self.assert_compile(
+            DropSequence(Sequence("foo_seq"), if_exists=True),
+            "DROP SEQUENCE IF EXISTS foo_seq",
+        )
+
 
 class SequenceExecTest(fixtures.TestBase):
     __requires__ = ("sequences",)