in DBMS by (10.3k points) edited by
0 like 0 dislike
28 views

Me need receive commentary of certain MySQL table. How I can get table comment in MySQL DBMS?

I did give commentary to certain table. How I can obtain access to determined table commentary in MySQL DBMS via SQL query?

How generally I can get access to table commentary in MySQL DBMS?


mysql get table comment
get mysql table commentary

1 Answer

0 like 0 dislike
by (10.3k points) edited by

You can get access to MySQL table commentary something like this (3 ways):

SHOW TABLE STATUS WHERE name = "my_table";
SELECT table_comment FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='my_db' AND table_name='my_tbl';
SELECT table_comment FROM INFORMATION_SCHEMA.TABLES WHERE table_name='my_tbl';

Your answer

Try to answer the question as detailed as possible.
Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.