Kbase P26283: How to get info about system files in SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/2/2003 |
|
Status: Unverified
GOAL:
How to query the system tables in SQL-92
FIX:
To query the system tables -
select * from sysprogress.systables
This lists the system tables.
Note that the schema identifier also has to be specified. To query, for example, the _File, the following sysntax should be used:
select * from pub."_File"
Because this file contains an underscore, it has to be treated as a delimited identifier.
Delimited identifiers are strings of no more than 32 ASCII characters enclosed in double quotation marks (""). Enclosing a name in double quotation marks preserves the case of the name and allows it to be a reserved word or to contain special characters. Special characters are any characters other than letters, digits, or the underscore character. Subsequent references to a delimited identifier must also use enclosing double quotation marks.