[MXS-3991] Implement show database,table,procedure,trigger,view and function info including indexes and foreign keys in the Query editor like show create table Created: 2022-02-09  Updated: 2023-08-14  Resolved: 2023-08-14

Status: Closed
Project: MariaDB MaxScale
Component/s: maxgui
Affects Version/s: None
Fix Version/s: 23.08.0

Type: New Feature Priority: Major
Reporter: Naresh Chandra Assignee: Duong Thien Ly
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MXS-4432 Show create database/Table/View or an... Closed
is duplicated by MXS-3842 More options to alter table Closed
Relates
relates to MXS-4364 Query Tab is not selecting the Defaul... Closed
Sprint: MXS-SPRINT-187, MXS-SPRINT-188

 Description   

As a DB user, when we click the table, procedure, trigger, view and function then it should show the info in the Query Editor like show create table.

Show that we can see indexes, foreign key and other details.



 Comments   
Comment by Naresh Chandra [ 2022-02-14 ]

Hi Duong,

Thanks for the update.

Comment by Duong Thien Ly [ 2023-08-08 ]

Hi naresh.chandra@copart.com, I see you update the ticket title, what do you mean by "show database"? what sort of information you would expect it to be?
My best guess is something like this "SHOW TABLE STATUS FROM schema_name"

Comment by Naresh Chandra [ 2023-08-08 ]

Duong Thien Ly,

We are expecting "show create database;"

Generated at Thu Feb 08 04:25:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.