BlaugranaGent BlaugranaGent - 1 year ago 130
SQL Question

Describe table SQL Oracle

How to describe table in SQL Oracle, I tried desc and describe, but it says desc not supported. I also tried mysql syntax show columns from table, but show is also unsupported?

Answer Source

You don't say what UI you are using, but DESC works in all of them that I know of. If it doesn't

SELECT * FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MY_TABLE'
AND OWNER = 'MY_SCHEMA';

is an alternative for getting the same information.