我没有看到这个答案，但嘿，这就是我所做的:

SELECT name FROM databaseName.sys.Tables;

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

简单地得到所有的重要信息与下面的SQL在Mysql

    SELECT t.TABLE_NAME , t.ENGINE , t.TABLE_ROWS ,t.AVG_ROW_LENGTH, 
t.INDEX_LENGTH FROM 
INFORMATION_SCHEMA.TABLES as t where t.TABLE_SCHEMA = 'YOURTABLENAMEHERE' 
order by t.TABLE_NAME ASC limit 10000;

对于postgres，它将是:

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

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

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

或者SELECT *获取所有列。

这很好

选择 ＊ 从 information_schema.tables;