BlaugranaGent BlaugranaGent - 1 month ago 6
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

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.