# Describe table - error

**URL:** <https://forums.toadworld.com/t/describe-table-error/55421>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 7, 2022, 9:09pm UTC](https://forums.toadworld.com/t/describe-table-error/55421 "2022-06-07T21:09:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![eransom3](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/eransom3/32/14767_2.png) [@eransom3](https://forums.toadworld.com/u/eransom3)\
**Post date:** [June 7, 2022, 9:09pm UTC](https://forums.toadworld.com/t/describe-table-error/55421/1 "2022-06-07T21:09:24Z")

</div>

This is the oddest thing, I'm getting an invalid sql error when i try to describe a table.  
Example:  
describe fimsmgr.fgrtots;  
returns  
Oracle Database Error: ORA-00900: invalid SQL statement.  
The table exists and I can select from it. I have access to dba\_tab\_cols, etc... I really don't understand what is giving me the invaid SQL statement. Is there a log I can check?  
Thanks!

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [June 13, 2022, 7:20am UTC](https://forums.toadworld.com/t/describe-table-error/55421/2 "2022-06-13T07:20:46Z")

</div>

DESCRIBE is a SQL\*Plus command, and not valid Oracle syntax, so it can't be executed within the TDP Editor.

You can achieve the same effect (viewing an object's meta-data) by choosing **View Details** off the right-click menu on an object listed in the Object Browser. This creates a "Viewer Doc Tab" on the right-hand side, and its Columns subtab contains the object's attributes, etc. See below...

 ![image](https://global.discourse-cdn.com/quest/original/2X/a/aaf18c97418d80acb3e74f695953625a259f74ec.png)

---

<div class="post-metadata">

**Author:** ![eransom3](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/eransom3/32/14767_2.png) [@eransom3](https://forums.toadworld.com/u/eransom3)\
**Post date:** [August 15, 2022, 10:38pm UTC](https://forums.toadworld.com/t/describe-table-error/55421/3 "2022-08-15T22:38:39Z")

</div>

That works! Thanks.
