How to query all table names under the current user in mysql

Mysql method to query all table names under the current user: execute the 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 the currently logged in user

(Recommended tutorial: mysql tutorial)

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_table

sp_columns t_table

Related recommendations:php training

The above is the detailed content of How to query all table names under the current user in mysql. For more information, please follow other related articles on the PHP Chinese website!