How to get table schema from Progress database via odbc

Question

Oh lovely Progress..

I have a linked server set up between sql 2008 and a Progress OpenEdge 10.1b server.

How do I get the table schemas?

Answer 1

You can do a statement like

SELECT * FROM LinkedProgressOpenedgeServer.YourDatabase.Owner.TableName WHERE 1=2

That should return just the schema without any data.