---
title: "How can display all table name in a Database ?"  
description: "How can display all table name in a Database ?"  
author: "Anonymous User"  
published: 2018-09-21  
updated: 2018-09-21  
canonical: https://www.mindstick.com/forum/34679/how-can-display-all-table-name-in-a-database  
category: "mssql server"  
tags: ["database", "sql server", "sql", "sql server 2008"]  
reading_time: 1 minute  

---

# How can display all table name in a Database ?

Hi,

I want to know that "how many [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) are [active](https://answers.mindstick.com/qa/97113/why-does-an-active-ftp-not-work-with-network-firewalls) in my [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax)" by a single [query in SQL](https://www.mindstick.com/forum/160921/help-with-writing-a-recursive-query-in-sql-server) server.

## Replies

### Reply by Anonymous User

Hi,

Rahul Ji,

I am giving you some database [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver), I hope that it will help you.

These are my database and table.

![How can display all table name in a Database ?](https://www.mindstick.com/mindstickforums/cad0e039-7f5d-4fd0-9554-18fa5146669b/images/de0286b1-87c3-4ff6-afcc-b64042e0c1e2.png)

Display All Table name in a Data Base at a time.

1). SELECT* FROM sys.Tables

![How can display all table name in a Database ?](https://www.mindstick.com/mindstickforums/cad0e039-7f5d-4fd0-9554-18fa5146669b/images/d73d75ff-a85d-4366-a013-e87c5f0b2d84.png)

2). SELECT*FROM information_schema.tables

![How can display all table name in a Database ?](https://www.mindstick.com/mindstickforums/cad0e039-7f5d-4fd0-9554-18fa5146669b/images/fd87440e-13dc-4c01-ac46-2d1412a32194.png)\

3). sp_tables '%cust%' --------(search table)

![How can display all table name in a Database ?](https://www.mindstick.com/mindstickforums/cad0e039-7f5d-4fd0-9554-18fa5146669b/images/892ab786-d711-4698-b746-6bdc467d3f72.png)\

4). SELECT * FROM sys.Tables WHERE name LIKE '%cus%'

![How can display all table name in a Database ?](https://www.mindstick.com/mindstickforums/cad0e039-7f5d-4fd0-9554-18fa5146669b/images/60b650cc-08d4-4cfa-821c-c94e048f4fe6.png)\

5). SELECT * FROM information_schema.tables WHERE table_name LIKE '%cust%'

![How can display all table name in a Database ?](https://www.mindstick.com/mindstickforums/cad0e039-7f5d-4fd0-9554-18fa5146669b/images/9444d191-54ab-4061-b76c-e5299c38af7f.png)\

\


---

Original Source: https://www.mindstick.com/forum/34679/how-can-display-all-table-name-in-a-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.