Home > DeveloperSection > Forums > How to find list of all user defined tables using SQL Server
Simond Gear
Simond Gear

Total Post:12

Points:84
Posted on    May-03-2016 11:54 PM

 Database Database  MSSQL Server  SQL Server  SQL  SQL Server 2008  SQL Server 2012 
Ratings:


 1 Reply(s)
 294  View(s)
Rate this:
Hi Everyone,

I have created a lots of tables in  sql server database. Now, i want to retrieve a list of all user defined tables in sql server.
Please can anyone give me a solution.

Thank you.


Anupam Mishra

Total Post:135

Points:949
Posted on    May-04-2016 12:08 AM

Hi Simond,

If you want to  retrieve a list of all user defined tables in MS SQL SERVER then you write the following queries:

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

Don't want to miss updates? Please click the below button!

Follow MindStick