我用adb中这个语句去删除全文索引，报错

根据报错在zjrcw_ads.company_info表上找不到fidx_company_name。先通过SHOW index from tbl_fulltext_name;，确定表的索引，此回答整理自钉群“云数据仓库ADB-开发者群”

云原生数据仓库AnalyticDB MySQL版支持通过ALTER TABLE修改表，具体语法格式

ALTER TABLE table_name
  {
    ADD [COLUMN] (column_name column_definition,...)
  | ADD {INDEX|KEY} [index_name] (column_name,...) 
  | ADD CLUSTERED [INDEX|KEY] [index_name] (column_name,...)
  | DROP [COLUMN] column_name
  | DROP {INDEX|KEY} index_name
  | DROP CLUSTERED [INDEX|KEY] index_name
  | MODIFY [COLUMN] column_name column_definition
  | RENAME COLUMN column_name to new_column_name
  | RENAME new_table_name
  | TRUNCATE PARTITION {partition_names | ALL}
  | STORAGE_POLICY= {'HOT'|'COLD'|'MIXED' [hot_partition_count=N]}
  | RT_ENGINE= {'ROWSTORE'|'COLUMNSTORE'} }

删除索引的语法应该是

ALTER TABLE db_name.table_name DROP KEY index_name;

比如删除CUSTOMER表中age列的索引。

ALTER TABLE adb_demo.customer DROP KEY age_idx;