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

Total Post:26

Points:182
 912  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. 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'

      Modified On Apr-11-2018 04:17:13 AM

Answer