How to Query Progress Metaschema in SQL-92


1. List names of all tables
select "_File-Name" from pub."_File";


-- this is the same as in Oracle
-- SELECT TABLE_NAME FROM DBA_TABLES;


2. List name and data type of all fields of a table (ABC)
select "_order" '#',
  "_Field-Name" 'Name',
  "_Data-Type",
  "_Width" 'SQL format',
  "_format" 'Progress format'
 from PUB."_Field"
 where "_Field"."_File-Recid" =
    (select "_File"."rowid"
     from PUB."_file" where "_file-name" = 'ABC')
 order by "_order";


-- This is the same as in Oracle
-- DESC ABC;

Return to myProgress Home Page

Hosted by www.Geocities.ws

1