2
(click on this box to dismiss)
How do I list information regarding a table?
How do I list information such as the columns, their data types and the constraints present on a table? Is there a possibility to list them all together?
![[Level:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 39 (63% completed for the next level)"){kind=icon}
andreyij![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)"){kind=icon}
CUBRID 2 years ago
1
Answer
0
You can use the following query to retrieve column information for a table.
SHOW COLUMNS {FROM | IN} tbl_name [LIKE 'pattern' | WHERE expr]That will show:
- column name
- type
- null or not
- primary key or not
- default value
- auto increment or not
For more information, see http://www.cubrid.org/manual/840/en/SHOW%20COLUMN%20Statement.
tagged
asked 2 years ago
viewed 568 times