1. Beatrix Willius
  2. Valentina Database ADK
  3. Суббота, Декабрь 30 2023, 11:26 AM
  4.  Подписаться через email
According to the docs I can drop an index by using:

DROP INDEX index_name ON table_name


But what are the names of the indexes? How can I drop the indexes for a complete table?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Beatrix,

SHOW INDEXES FROM table_name


Returns the names of indexes, each one can be removed individually.
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
Thanks! Got it.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories