Kbase 20690: What is the Numbering Convention for Schema Tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/3/2008 |
|
Status: Verified
GOAL:
What is the numbering convention used for the schema tables (_file._file-number).
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".