Table, view, and sequence commands¶ Table, view, and sequence commands enable you to manage your tables, views, and sequences. General database objects¶ SHOW OBJECTS Table¶ CREATE TABLE ALTER TABLE DESCRIBE TABLE DROP TABLE UNDROP TABLE SHOW TABLES SHOW COLUMNS SHOW PRIMARY KEYS DESCRIBE SEARCH OPTIMIZATION TRUNCATE TABLE Dynamic table¶ CREATE DYNAMIC TABLE ALTER DYNAMIC TABLE DESCRIBE DYNAMIC TABLE DROP DYNAMIC TABLE SHOW DYNAMIC TABLES Event table¶ CREATE EVENT TABLE ALTER TABLE (event tables) SHOW EVENT TABLES DESCRIBE EVENT TABLE External table¶ CREATE EXTERNAL TABLE ALTER EXTERNAL TABLE DESCRIBE EXTERNAL TABLE DROP EXTERNAL TABLE SHOW EXTERNAL TABLES Hybrid table¶ CREATE HYBRID TABLE CREATE INDEX DROP INDEX SHOW HYBRID TABLES SHOW INDEXES Apache Iceberg™ table¶ CREATE ICEBERG TABLE ALTER ICEBERG TABLE DROP ICEBERG TABLE UNDROP ICEBERG TABLE SHOW ICEBERG TABLES DESCRIBE ICEBERG TABLE View¶ CREATE VIEW ALTER VIEW DESCRIBE VIEW DROP VIEW SHOW VIEWS Materialized view¶ CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW DESCRIBE MATERIALIZED VIEW DROP MATERIALIZED VIEW SHOW MATERIALIZED VIEWS TRUNCATE MATERIALIZED VIEW Sequence¶ CREATE SEQUENCE ALTER SEQUENCE DESCRIBE SEQUENCE DROP SEQUENCE SHOW SEQUENCES