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