[kingbase@host1 KingbaseES]$ ksql test system
Password for user system:
ksql (V8.0)
Type "help" for help.
test=# \d+ tab1_index
Index "public.tab1_index"
Column | Type | Key? | Definition | Storage | Stats target
--------+---------+------+------------+---------+--------------
id | integer | yes | id | plain |
btree, for table "public.tab1"
test=# alter index tab1_index rename to index_tab1;
ALTER INDEX
test=# \d+ tab1_index
Did not find any relation named "tab1_index".
test=# \d+ index_tab1
Index "public.index_tab1"
Column | Type | Key? | Definition | Storage | Stats target
--------+---------+------+------------+---------+--------------
id | integer | yes | id | plain |
btree, for table "public.tab1"
金仓数据库修改索引名
最新推荐文章于 2024-06-07 09:45:58 发布