---
title: "How to find list of all user defined tables using SQL Server"  
description: "How to find list of all user defined tables using SQL Server"  
author: "Simond Gear"  
published: 2016-05-03  
updated: 2016-05-04  
canonical: https://www.mindstick.com/forum/34125/how-to-find-list-of-all-user-defined-tables-using-sql-server  
category: "database"  
tags: ["database", "mssql server", "sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# How to find list of all user defined tables using SQL Server

Hi Everyone,\
I have created a lots of tables in sql [server database](https://www.mindstick.com/forum/156824/what-is-normalization-in-sql-server-database). Now, i want to [retrieve](https://www.mindstick.com/forum/34400/how-to-retrieve-form-values-in-controller-action) a list of all [user defined](https://www.mindstick.com/interview/23047/how-to-create-user-defined-exception) [tables in sql](https://www.mindstick.com/forum/204/count-number-of-tables-in-sql-server) server.Please can [anyone give me](https://answers.mindstick.com/qa/41194/can-anyone-give-me-some-high-and-low-points-of-each-of-the-four-first-presidential-administrations) a solution.\
Thank you.

## Replies

### Reply by Anupam Mishra

Hi Simond,\
If you want to retrieve a list of all [user](https://www.mindstick.com/articles/13001/multi-statement-table-valued-user-defined-function-in-sql-server) defined [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in MS [SQL SERVER](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) then you write the following queries:\

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


---

Original Source: https://www.mindstick.com/forum/34125/how-to-find-list-of-all-user-defined-tables-using-sql-server

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