How to get a list of all tables in a SQL Server database?

Was this helpful?

0 votes

How do I get all the names of tables in a specific database on SQL Server?

Sep 21, 2016.

share edit

Harkrishna Nair
{ 50 - 1 - 0 }

add comment

1 Answers

Was this helpful?

0 votes

In SQL Server 2005 or better it is

SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE'

For SQL Server 2000 the syntax is:

SELECT * FROM sysobjects WHERE xtype='U'

Sep 21, 2016.

share edit

Henry Newby
{ 50 - 1 - 0 }

add comment

Your Answer

We'll remember your Answer.

Looking for a job?

Startup (stealth)

London, UK

Microsoft

Seattle

JP/Morgan Chase

Dallas, Texas

Accenture

New York

•	How do I prevent SQL injection in .NET?
•	How to get a list of all tables in a SQL Server database?
•	Difference between INNER JOIN and OUTER JOIN in SQL Server
•	How do I check that a column exists in a SQL Server table?
•	How to add a new column, with a default value, to an existing table in SQL Server
•	How to add a new column, with a default value, to an existing table in SQL Server
•	How to add a new column, with a default value, to an existing table in SQL Server
•	How to name tables in a database: Singular or Plural?
•	Server Side Rendering
•	Server Side Rendering in JavaScript?