How does mysql query all table names under the current user?

Xiaobian to share with you how mysql query all the table names under the current user, I believe most people still do not know how to share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

mysql query all table names under the current user: execute sql statement [select * from sys.objects where type='U' order by name]. If you want to view the table structure, you can execute the sp_help t_table statement.

View all table names under current login user

select name from sys.objects where type='U' order by name select * from sys.objects where type='U' order by name

Table structure query

sp_help t_tablesp_columns t_table above is mysql how to query all the contents of all table names under the current user, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!