How to View Table Structure in Toad?

  • Post author:
  • Post category:Toad
  • Reading time:2 mins 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:

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.