【sql】如何用sql获取数据库中所有表名？

sqlserver

use db_name
select name from sysobjects where xtype='u'
go

mysql

select table_name from information_schema.tables where table_schema='db_name'