Search code examples
sqlopenedgeprogress-db

Select Column Names for OpenEdge-SQL

I'm using DBeaver to connect to Open-Edge 11 database which supports SQL functions. The functions used HERE don't work. Here is a single example and the result:

Function:

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'TxMSAGrading'

Error:

SQL Error [42S02]: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/view/synonynm "INFORMATION_SCHEMA.COLUMNS" cannot be found. (15814)

How can I get column names?

Solution

  • Column information is stored in Progress system tables called "syscolumns". Here is an example to retrieve column information of the "Customer" table:

    select col from sysprogress.syscolumns where tbl = 'customer';
COL
--------------------------------
Address
Address2
Balance
City
Comments
Contact
Country
Credit-Limit
Cust-Num
Discount
Name
Phone
Postal-Code
Sales-Rep
State
Terms

    List of all the system tables in Progress OpenEdge is here.