Press "Enter" to skip to content

How to View Table Structure in Toad?

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

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *