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 Semantic viewÂļ CREATE SEMANTIC VIEW ALTER SEMANTIC VIEW DESCRIBE SEMANTIC VIEW DROP SEMANTIC VIEW SHOW SEMANTIC VIEWS SHOW SEMANTIC DIMENSIONS SHOW SEMANTIC FACTS SHOW SEMANTIC METRICS SHOW SEMANTIC DIMENSIONS FOR METRIC SequenceÂļ CREATE SEQUENCE ALTER SEQUENCE DESCRIBE SEQUENCE DROP SEQUENCE SHOW SEQUENCES