Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


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?

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.

link comment (0)
answered 3 years ago
dba
558
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: