I have a linked server set up between sql 2008 and a Progress OpenEdge 10.1b server.
How do I get the table schemas?
You can get all available tables:
select * from sysprogress.SYSTABLES;
or
select * from sysprogress.SYSTABLES_FULL;
You can get all columns of specified table:
select * from sysprogress.SYSCOLUMNS where TBL = 'table_name';
or
select * from sysprogress.SYSCOLUMNS_FULL where TBL = 'table_name';
It works only with DBA privileged user.
More detail in OpenEdge Product Documentation: https://community.progress.com/community_groups/openedge_general/w/openedgegeneral/1329.openedge-product-documentation-overview
Document title: SQL Reference
Chapter: OpenEdge SQL System Catalog Tables