Description
noneTable properties
| name | value |
|---|
| name | DBA.zzz_object_comments |
| row count | 3 |
| Maximum size of a single row | 2,748 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| LevelZeroName | varchar(100) | 100 | | yes
|
| |
| |
| LevelZeroType | varchar(100) | 100 | | yes
|
| |
| |
| LevelOneName | varchar(100) | 100 | | yes
|
| |
| |
| LevelOneType | varchar(100) | 100 | | yes
|
| |
| |
| LevelTwoName | varchar(100) | 100 | | yes
|
| |
| |
| LevelTwoType | varchar(100) | 100 | | yes
|
| |
| |
| PropName | varchar(100) | 100 | | no
|
| |
| |
| PropVal | varchar(2048) | 2048 | | no
|
| |
| |
Sample rows
| LevelZeroName | LevelZeroType | LevelOneName | LevelOneType | LevelTwoName | LevelTwoType | PropName | PropVal |
|---|
| GROUPO
| USER
| Customers
| TABLE
|
|
| MS_Description
| test
|
| GROUPO
| USER
| Contacts
| TABLE
|
|
| MS_Description
| another test
|
| GROUPO
| USER
| Customers
| TABLE
| ID
| COLUMN
| MS_Description
| a column comment
|
Code
CREATE TABLE "DBA"."zzz_object_comments" (
"LevelZeroName" varchar(100) NULL
,"LevelZeroType" varchar(100) NULL
,"LevelOneName" varchar(100) NULL
,"LevelOneType" varchar(100) NULL
,"LevelTwoName" varchar(100) NULL
,"LevelTwoType" varchar(100) NULL
,"PropName" varchar(100) NOT NULL
,"PropVal" varchar(2048) NOT NULL
)