How to export list of tables in SQL Server with SSMS

Article for: Toad for Oracle Toad for SQL Server Aqua Data Studio

Sometimes you might want to copy list of all tables in the database. In this article I'd like to show you how you can do it quickly with SSMS, as it's not obvious right away. You probably noticed that you can't select all tables in the Object Explorer.

But don't worry, there's another way. First, enable Object Explorer Details going to View > Object Explorer Details or by pressing F7 buton.

Now, select Tables element in your database in Object Explorer. List of tables with details will show in in the right pane in Object Explorer Details tab. You are able to select all tables in this grid and copy to clipboard.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.