Figure 2: Example portions of the five tables used by create.table
---------------------------------------------------------
| sysobjects |
| ---------- |
| name id uid type userstat sysstat |
| ----------- -- --- ---- -------- ------- |
| syssegments 7 1 S 0 1 |
|-------------------------------------------------------|
| sysindexes |
| ---------- |
| name id idid dpages segment user |
| ----------- -- ---- ------ ------- ---- |
| syssegments 7 0 1 0 2 |
|-------------------------------------------------------|
| syssegments |
| ----------- |
| segment name status |
| ------- ------ ------ |
| 0 system 0 |
|-------------------------------------------------------|
| syscolumns |
| ---------- |
| id colid status length usertype name |
| -- ----- ------ ------ -------- ------- |
| 7 1 0 2 6 segment |
| 7 2 0 30 18 name |
| 7 3 8 2 13 status |
|-------------------------------------------------------|
| systypes |
| -------- |
| uid usertype type length name |
| --- -------- ---- ------ -------- |
| 1 13 38 4 intn |
| 1 6 52 2 smallint |
| 1 18 39 30 sysname |
---------------------------------------------------------
|