当前位置：网站首页>Oracle and MySQL batch query all table names and table name comments under users

Oracle and MySQL batch query all table names and table name comments under users

2022-04-23 13:41:00 【Wangcai 2】

Oracle Look up ：

SELECT table_name Table name ,table_comment Table description FROM information_schema.TABLES WHERE
table_schema = ' user name '
ORDER BY table_name desc

MySQL Look up ：

select table_name,comments from user_tab_comments order by table_name desc

版权声明
本文为[Wangcai 2]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230604300231.html

边栏推荐

猜你喜欢

随机推荐