How to View Table Structure in Toad?

How to View Table Structure in Toad?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 1 min read

There are 2 ways to view table stucture in Toad for Oracle. The following are the examples.

Follow these steps to view table structure in Toad.

Using SQL Editor

  1. In Toad Editor, type the name of the table and press F4.
  2. A window will pop-up and in Columns Tab you can view the table structure.
  3. But if you want to view the script, then click on the Script Tab, there you can see the table script.

Using Schema Browser

  1. In Toad, click on the menu Database > Schema Browser.
  2. Then schema browser window will open and you will see list of tables displayed in the Tables tab.
  3. Select the table for which you want to see the structure.
  4. Then it will display the structure in Columns Tab at right side of the window.
  5. If you want to see the script, click on the Scripts Tab, there you can see the table script.

See also: