对于postgres，它将是:

SELECT table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema  = 'your_schema' -- probably public 

select * from sys.tables
order by schema_id      --comments: order by 'schema_id' to get the 'tables' in 'object explorer order'
go

更新MSSQL服务器的最新版本(17.7)

SELECT name FROM sys.Tables WHERE type_desc = 'USER_TABLE'

或者SELECT *获取所有列。

根据Michael Baylon的回答，我需要一个包含模式信息的列表，这就是我修改他的查询的方式。

SELECT TABLE_SCHEMA + '.' + TABLE_NAME as 'Schema.Table'
  FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG = 'dbName'
  ORDER BY TABLE_SCHEMA, TABLE_NAME

下面的查询将选择数据库中所有名为DBName的表:

USE DBName
GO 
SELECT *
FROM sys.Tables
GO

对于Mysql，你可以做的很简单。显示表;