I would like to view table structure in sql ; do we have any alternate command for describe <table name>;

Question

I would like to view table structure in sql ; do we have any alternate command for describe <table name>;

Answer 1

it will likely depend on your IDE. for example, if you're using SQL developer, you can Ctrl + Right Click on the table name to see the table structure including comments. alternatively, what I use more often than anything because of speed, is select * from TABLE where rownum =1;