Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Simond Gear 2200 03 May 2016

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.

1 Answers

Anupam Mishra 04 May 2016

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'

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.