Got Tables?

When working with a database there may be a time you want to get a handle on what and how many tables you have in a particular database.  You can run the following statement and get back a list of user created tables in the database.  One thing to note is if you don’t have permissions to select against certain tables they will be omitted from the result set.  I normally work in SQL as SA so this doesn’t happen to me.

 

 

USE master; –Enter your database name here. I used MASTER
GO
SELECT *
FROM sys.Tables

 

Posted in SQL

1 thought on “Got Tables?

  1. Jon Reply

    I am not surе where you’re getting your informatiօn,
    but good topic. I ոeeds to spend sоme time
    learnіng much more or understanding more. Thanks for excellent info I was looking for this info for my
    mission.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.