In this article, I will show you how to export a list of tables using Toad for SQL Server tool.
In Object Explorer expand database, then right click on Tables branch and select View details.
A new window Viewer contains a list of tables with basic information about them. Before we export this list we can get rid of useless columns. We can do this by right click on column header we want to get rid of and select Hide This Column.
To export a prepared list of tables:
- select all rows (CTRL + A combination) and just copying it to the clipboard (CTRL + C). Next we can paste it in Excel or other tool.
- above list of tables click on the Export data to a Excel, CSV or HTML button.