Describe table using SQL-92 \ 4GL

[sudipta]

Hi,

I am new to SQL-92 \ 4GL..

I want to describe table using SQL-92 \ 4GL , as in Oracle...

Can any one help me...

 

[DevTeam]

Hi,

I am new to SQL-92 \ 4GL..

I want to describe table using SQL-92 \ 4GL , as in Oracle...

Can any one help me...

Do you mean creating table without using the Data Dictionnary ? Then have a look at CREATE TABLE statement in the online documentation. http://progress.atgnow.com/esprogress/categoryBrowse.do

However, tables created this way won't be updatable through the data dictionnary...

I take the opportunity to ask the community what are the main differences between DataDictionnary tables and SQL tables, talking about performances for example.

Thanks in advance,

Julien

 

[D.Cook]

I have not used SQL with Progress before but I'm guessing the meta tables are available.
Try selecting from the tables _file (table), _field and _index.

Or if you have a 4GL license, open the Data Dictionary. This is under 'Tools' in the Procedure Editor.

Otherwise check out the OpenEdge documentation
http://www.psdn.com/library/kbcategory.jspa?categoryID=1592