表、视图、序列和用户定义类型命令¶ 使用表、视图、序列和用户定义类型命令,可以管理表、视图、序列和用户定义类型。 常规数据库对象¶ SHOW OBJECTS 表¶ CREATE TABLE ALTER TABLE DESCRIBE TABLE DROP TABLE UNDROP TABLE SHOW TABLES SHOW COLUMNS SHOW PRIMARY KEYS DESCRIBE SEARCH OPTIMIZATION TRUNCATE TABLE 动态表¶ CREATE DYNAMIC TABLE ALTER DYNAMIC TABLE DESCRIBE DYNAMIC TABLE DROP DYNAMIC TABLE SHOW DYNAMIC TABLES 事件表¶ CREATE EVENT TABLE ALTER TABLE(事件表) SHOW EVENT TABLES DESCRIBE EVENT TABLE 外部表¶ CREATE EXTERNAL TABLE ALTER EXTERNAL TABLE DESCRIBE EXTERNAL TABLE DROP EXTERNAL TABLE SHOW EXTERNAL TABLES 混合表¶ CREATE HYBRID TABLE CREATE INDEX DROP INDEX SHOW HYBRID TABLES SHOW INDEXES Apache Iceberg™ 表¶ CREATE ICEBERG TABLE ALTER ICEBERG TABLE DROP ICEBERG TABLE UNDROP ICEBERG TABLE SHOW ICEBERG TABLES DESCRIBE ICEBERG TABLE 视图¶ CREATE VIEW ALTER VIEW DESCRIBE VIEW DROP VIEW SHOW VIEWS 物化视图¶ CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW DESCRIBE MATERIALIZED VIEW DROP MATERIALIZED VIEW SHOW MATERIALIZED VIEWS TRUNCATE MATERIALIZED 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 用户定义的类型¶ CREATE TYPE ALTER TYPE DESCRIBE TYPE SHOW TYPES DROP TYPE UNDROP TYPE 序列¶ CREATE SEQUENCE ALTER SEQUENCE DESCRIBE SEQUENCE DROP SEQUENCE SHOW SEQUENCES