2
(click on this box to dismiss)
how do i list columns from a table
How do I list the columns from a table using a SQL Query?
link
comment (1)
accepted answer
asked 2 years ago
![[Level:3]](http://www.cubrid.org/modules/point/icons/default/3.gif "Rank: 3/30, reputation score 54 (8% completed for the next level)"){kind=icon}
pevensie54
http://www.cubrid.org/questions/237174 - ![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)")
CUBRID 2 years ago
CUBRID 2 years ago
1
Answer
0
SHOW COLUMNS FROM mytable;
You can also filter the columns based on some condition like:
SHOW COLUMNS FROM mytable WHERE "type" = 'INTEGER';
For more information, see the manual http://www.cubrid.org/manual/840/en/SHOW%20COLUMN%20Statement.
tagged
asked 2 years ago
viewed 598 times