Kbase P13656: Numbering Convention for Schema Tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/21/2003 |
|
Status: Unverified
GOAL:
Numbering Convention for Schema Tables
GOAL:
This solution explains the numbering convention used for the schema
tables (_file._file-number).
FACT(s) (Environment):
Progress 9.x
FIX:
The schema table numbering convention is as follows:
- All table numbers less than zero are metaschema tables.
- Table numbers in the range -8 to -28 are old, fast track tables
that might be present in a converted database. They are not
used.
- Table numbers -16383 and below are for virtual system tables.
The conventions for SQL catalog tables are as follows:
- SQL catalog tables are owned by SYSPROGRESS.
- SQL catalog tables names start with _SYS.
- SQL catalog view names start with SYS.
User-defined tables have numbers greater than 0.
If they were not
created by SQL, they are owned by "PUB".