How to print a list of column names?

Classic Servoy
1

I would like to print a list of all my columns (name, type, length) in a table of the Sybase db.
How can I do this?

Thanks in advance,
Thomas

2

databaseManager.getTable() gives you a JSTable object. From that you get to columns…

3

hmm…, but I thought there is perhaps an easy way to print out the list of columns, displayed in Servoy Developer…!?

4

Within Sybase Central right-click on any Table name and select “Copy” from the popup. Then paste into Notepad. For example, pasted Contact table information would look something like:

CREATE TABLE “DBA”.“contacts” (
“contact_id” integer NOT NULL,
“name_first” varchar(200) NULL,
“name_middle” varchar(200) NULL,
“name_last” varchar(200) NULL,
“company” varchar(255) NULL,
“address1” varchar(255) NULL,
“address2” varchar(255) NULL,
“city” varchar(255) NULL,
“state” varchar(25) NULL,
“zip” varchar(50) NULL,
“salutation” varchar(50) NULL,
“contact_name” varchar(255) NULL,
PRIMARY KEY ( “contact_id” )
);

5

Westy:
Within Sybase Central right-click on any Table name and select “Copy” from the popup. Then paste into Notepad.

Cool! That’s what I’m looking for.
Thank you Westy for this reply.