How to list all columns in database with Toad for SQL Server

This article will show you how to list all columns in a database.

Open Find tool which you can find as icon in main menu, under Tools -> Find or by pressing F4 key.

In new opened window (Object Search):

  1. in Database section choose a database
  2. in Object types uncheck all by right click -> Uncheck All
  3. in Search textbox provide wildcard sign (%)
  4. in Column search section check Tables
  5. click on Search button (or Append to add new search results to current results)
  6. you can change column order for better readability by drag and drop column header to grouping section