All Products
Search
Document Center

DROP SEQUENCE

Last Updated: Jun 18, 2021

Description

This statement deletes an auto-increment column.

Syntax

DROP SEQUENCE sequence_name

Parameter description

Parameter

Description

sequence_name

The name of the auto-increment column to be deleted.

Examples

  • Delete the auto-increment column S1.

OceanBase(TEST@TEST)>drop sequence S1;
Query OK, 0 rows affected (0.16 sec)