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?

2 Answers
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 4 years ago
dba
558
0
#file_links[D:\CP\Coachkc\link-a.txt] well worth talking about Possibly be, in 1996 France entire world glass, Beckham Mu due to the fact reprisal the west get Ni nevertheless become punished by way of the reddish colored credit card underside, that location is perhaps
link comment (0)
answered 3 weeks ago
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: