HOW TO FIND LIST OF ALL USER DEFINED TABLES USING SQL SERVER

Simond Gear

Total Post:26

Points:182
Posted by  Simond Gear
 587  View(s)
Ratings:
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.
  1. Anupam Mishra

    Post:135

    Points:949
    Re: How to find list of all user defined tables using SQL Server

    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'

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!