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