Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is most likely no translated for the post!




Microsoft SQLServer...
 
Share:
Notifications
Clear all

Microsoft SQLServer - How to create a list of my tables


 Hans
(@hans)
Noble Member Admin
Joined: 8 years ago
Posts: 1891
Topic starter  

Just a little task I had to look into and figure out: 

On Microsoft SQL Server; how do I get a list of all the tabels in my database?
A simple SQL statement will reveal this for you:

SELECT NAME 
FROM DATABASENAME.SYS.TABLES 
ORDER BY NAME 

Where "DATABASENAME" should be the name of your database of course.


ReplyQuote

Like what you see and you'd like to help out? 

The best way to help is of course by assisting others with their questions here in the forum, but you can also help us out in other ways:

- Do your shopping at Amazon, it will not cost you anything extra but may generate a small commission for us,
- send a cup of coffee through PayPal ($5, $10, $20, or custom amount),
- become a Patreon,
- donate BitCoin (BTC), or BitCoinCash (BCH).

Share: