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

Total Post:26

Points:182

 1132  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. 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

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.