sql-server - 如何使用TSQL获取数据库中所有表的列表？(How do I get list of all tables in a database using TSQL?)

Question

在SQL Server上的特定数据库中获取所有表名的最佳方法是什么？

  ask by Ray Vega translate from so

Answer 1

SQL Server 2005, 2008, 2012, 2014, 2016, 2017 or 2019:

(SQL Server 2005、2008、2012、2014、2016、2017或2019：)

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

To show only tables from a particular database

(仅显示特定数据库中的表)

SELECT TABLE_NAME 
FROM <DATABASE_NAME>.INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'BASE TABLE'

Or,

(要么，)

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'BASE TABLE' 
    AND TABLE_CATALOG='dbName' --(for MySql, use: TABLE_SCHEMA='dbName' )

PS: For SQL Server 2000:

(PS：对于SQL Server 2000：)

SELECT * FROM sysobjects WHERE xtype='U'