- 1

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

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

21st Jun 2018, 9:17 AM
Vasanth
1 Answer
0
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;
4th Jul 2018, 12:49 AM
Jason Huber
Jason Huber - avatar