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
Related Posts
About The Author
jcox@hexoma.com
One Comment
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.