ALL_OBJECTS

C.10 ALL_OBJECTS

Oracle Database Gateway for SQL ServerのALL_OBJECTSデータ・ディクショナリ。

名前	タイプ	値
`OWNER`	`VARCHAR2(256)`	-
`OBJECT_NAME`	`VARCHAR2(256)`	-
`SUBOBJECT_NAME`	`VARCHAR2(1)`	`NULL`
`OBJECT_ID`	`NUMBER`	-
`DATA_OBJECT_ID`	`NUMBER`	`0`
`OBJECT_TYPE`	`VARCHAR2(9)`	"`TABLE`"または"`VIEW`"または"`INDEX`"または"`PROCEDURE`"
`CREATED`	`DATE`	-
`LAST_DDL_TIME`	`DATE`	-
`TIMESTAMP`	`VARCHAR2(1)`	`NULL`
`STATUS`	`VARCHAR2(5)`	"`VALID`"
`TEMPORARY`	`VARCHAR2(1)`	`NULL`
`GENERATED`	`VARCHAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`

親トピック: データ・ディクショナリ