forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
75 lines
6.0 KiB
HTML
75 lines
6.0 KiB
HTML
<a name="EN-US_TOPIC_0000001811491369"></a><a name="EN-US_TOPIC_0000001811491369"></a>
|
|
|
|
<h1 class="topictitle1">ALL_OBJECTS</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000001811491369__af3d040f7b32548929ccd4ebcd7f98e06"><strong id="EN-US_TOPIC_0000001811491369__b18476112745820">ALL_OBJECTS</strong> displays all database objects accessible to the current user.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811491369__t6c3e84cfd6f145f785257ab060de9745" frame="border" border="1" rules="all"><caption><b>Table 1 </b>ALL_OBJECTS columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001811491369__rc1b2add168364065bc0d8d2de8b82e37"><th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001811491369__a2446cc1051524f1385e97f31a03cd6cf"><strong id="EN-US_TOPIC_0000001811491369__b31011669443514">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="30%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001811491369__a6527e9147f6143c9af087bbe126f3bc3">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="50%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001811491369__a1cbb3f90c8734bb3985ea7b8faa7cecc">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001811491369__rf7006ae4a3db49e39486e98bb03c5fda"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__a076426b7d7db44f698da45a8947af953">owner</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__a97845fbe16d94016b5f69bd79dde8e49">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__a70e2dd4fe7b04827866408b46ef79531">Owner of the object</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491369__r7baa95c43eae47bcad6ff0d4e1cc0c59"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__a0a69ed17b8af4c7198f4e880bdd41856">object_name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__a88350e74edf24e0e90a7984599851507">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__a94c836d1b6084a88a4e3e87a46c96621">Object name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491369__re831a9a96761410397b65b6d14af2a15"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__a1c8f60c175cc4c80b35cbdd3befeb9a7">object_id</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__ad12f95276e5145f98875ecf209fc9e55">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__a27f08ae9b10640c1bedef465f80d1576">OID of the object</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491369__r819d4c74d81b4b0f8cb1320cf778c0ea"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__a76da838716a54f31bebce605bc309239">object_type</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__a4ae210de46c645798d0d5406fcd72be6">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__adab91511c2ba4022b5687ce324522395">Type of the object</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491369__r8a53adf0804d4ff5ae7de5a567ab6dbd"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__a8b25c4cd3ae54d96a7049086745829c3">namespace</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__aaf5c44e2f38c4666a7a68e4ab7657380">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__a4fdfc6e5fdb042c2b8921088162f0f29">Namespace containing the object</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491369__row17810204101315"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__p8810134121320">created</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__p1181010491316">Timestamp with time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__p1981004131311">Object creation time</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491369__row139141013131"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491369__p16391610141314">last_ddl_time</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="30%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491369__p18391010161314">Timestamp with time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491369__p6392010191317">Last time when the object was modified</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<div class="notice" id="EN-US_TOPIC_0000001811491369__note48614535129"><span class="noticetitle"><img src="public_sys-resources/notice_3.0-en-us.png"> </span><div class="noticebody"><p id="EN-US_TOPIC_0000001811491369__p178685311213">For details about the value ranges of <strong id="EN-US_TOPIC_0000001811491369__b11424233716">last_ddl_time</strong> and <strong id="EN-US_TOPIC_0000001811491369__b922712812715">last_ddl_time</strong>, see <a href="dws_04_0601.html">PG_OBJECT</a>.</p>
|
|
</div></div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0639.html">System Views</a></div>
|
|
</div>
|
|
</div>
|
|
|