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 no translation for that post!
[Solved] Microsoft SQLServer - How to create a list of my tables
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2858
Topic starter
December 16, 2016 6:49 AM
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.
