PL/SQL Developer如何查看表结构

ゝ一纸荒年。 2022-02-19 11:23 435阅读 0赞

1.  方式一：
    
    按住ctrl键不放，鼠标左键点击表名称，即显示表的一切详细情况（表空间，表名称，索引，列，键，权限，触发器 ...）
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer]][PL_SQL Developer_PL_SQL Developer]
2.   
    
    方式二：
    
    在命令窗口（command）输入sql命令：desc table\_name;  显示表每一列（字段）的详细情况
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 1]][PL_SQL Developer_PL_SQL Developer 1]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 2]][PL_SQL Developer_PL_SQL Developer 2]
3.   
    
    方式三：
    
    在sql窗口，鼠标右键点击表名称，选择鼠标左键点击‘属性（attribute)’可以查看该表的建表，建主键，建索引的脚本。
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 3]][PL_SQL Developer_PL_SQL Developer 3]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 4]][PL_SQL Developer_PL_SQL Developer 4]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 5]][PL_SQL Developer_PL_SQL Developer 5]
4.   
    
    方式四：
    
    在sql窗口，鼠标右键点击表名称，选择鼠标左键点击‘描述（describe）’显示表每一列（字段）的详细情况
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 6]][PL_SQL Developer_PL_SQL Developer 6]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 7]][PL_SQL Developer_PL_SQL Developer 7]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 8]][PL_SQL Developer_PL_SQL Developer 8]
5.   
    
    方式五：
    
    在sql窗口，鼠标右键点击表名称，选择鼠标左键点击‘查看（view）’即显示表的一切详细情况（表空间，表名称，索引，        列，键，权限，触发器 ...）
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 9]][PL_SQL Developer_PL_SQL Developer 9]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 10]][PL_SQL Developer_PL_SQL Developer 10]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 11]][PL_SQL Developer_PL_SQL Developer 11]
6.   
    
    方式六：
    
    在sql窗口，鼠标右键点击表名称，选择鼠标左键点击‘编辑（edit）’即显示表的一切详细情况（表空间，表名称，索引，        列，键，权限，触发器 ...）
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 12]][PL_SQL Developer_PL_SQL Developer 12]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 13]][PL_SQL Developer_PL_SQL Developer 13]
    
    [![PL/SQL Developer如何查看表结构][PL_SQL Developer 14]][PL_SQL Developer_PL_SQL Developer 14]

[PL_SQL Developer]: https://imgsa.baidu.com/exp/w=500/sign=994b19bbc71b9d168ac79a61c3dfb4eb/fc1f4134970a304eca922b9ed8c8a786c9175c26.jpg
[PL_SQL Developer_PL_SQL Developer]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png
[PL_SQL Developer 1]: https://imgsa.baidu.com/exp/w=500/sign=bfe5f1ae8b8ba61edfeec82f713597cc/ac6eddc451da81cb370b74a95b66d016082431e0.jpg
[PL_SQL Developer_PL_SQL Developer 1]: /images/20220219/35cd0b8e6b9a4be3acecb6432e286c3a.png
[PL_SQL Developer 2]: https://imgsa.baidu.com/exp/w=500/sign=0471f97d24f5e0feee1889016c6134e5/6609c93d70cf3bc76b533b88d800baa1cd112a07.jpg
[PL_SQL Developer_PL_SQL Developer 2]: /images/20220219/4b65c61706da4e48b43961849e070a28.png
[PL_SQL Developer 3]: https://imgsa.baidu.com/exp/w=500/sign=4b2099343da85edffa8cfe23795409d8/f9dcd100baa1cd11859a8244b012c8fcc3ce2da2.jpg
[PL_SQL Developer_PL_SQL Developer 3]: /images/20220219/4f25d1ecf4254ad7b3b2509d2ca8ef21.png
[PL_SQL Developer 4]: https://imgsa.baidu.com/exp/w=500/sign=7d39d09a3fd3d539c13d0fc30a86e927/7aec54e736d12f2e0deb5e0446c2d562843568ec.jpg
[PL_SQL Developer_PL_SQL Developer 4]: /images/20220219/cb1e0e3ebe414fd7860e86061575a8c4.png
[PL_SQL Developer 5]: https://imgsa.baidu.com/exp/w=500/sign=7e4615f605f431adbcd243397b37ac0f/2cf5e0fe9925bc319091f1fc57df8db1ca137082.jpg
[PL_SQL Developer_PL_SQL Developer 5]: /images/20220219/7b00370d81a84b6bbec44d0dca30591a.png
[PL_SQL Developer 6]: https://imgsa.baidu.com/exp/w=500/sign=9613bba48b025aafd3327ecbcbedab8d/86d6277f9e2f07086f38d764e024b899a901f291.jpg
[PL_SQL Developer_PL_SQL Developer 6]: /images/20220219/c025107ac2c447e8ae279a174aa0ef0a.png
[PL_SQL Developer 7]: https://imgsa.baidu.com/exp/w=500/sign=ea8f69df8ed6277fe912323818391f63/472309f7905298221f80c4a7deca7bcb0a46d427.jpg
[PL_SQL Developer_PL_SQL Developer 7]: /images/20220219/94ede4be708f480f9362c09414b37ef5.png
[PL_SQL Developer 8]: https://imgsa.baidu.com/exp/w=500/sign=b67b63300a4f78f0800b9af349300a83/e824b899a9014c082390d5c1037b02087bf4f42f.jpg
[PL_SQL Developer_PL_SQL Developer 8]: /images/20220219/df3599ca94ed422b9e5c3c8bbd301a4c.png
[PL_SQL Developer 9]: https://imgsa.baidu.com/exp/w=500/sign=84f8189cae86c91708035239f93d70c6/962bd40735fae6cd6abb570506b30f2442a70f42.jpg
[PL_SQL Developer_PL_SQL Developer 9]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png0
[PL_SQL Developer 10]: https://imgsa.baidu.com/exp/w=500/sign=5a747f4de2c4b7453494b716fffc1e78/03087bf40ad162d9a2f29b7818dfa9ec8a13cdb2.jpg
[PL_SQL Developer_PL_SQL Developer 10]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png1
[PL_SQL Developer 11]: https://imgsa.baidu.com/exp/w=500/sign=bbf3fa87dc39b6004dce0fb7d9513526/55e736d12f2eb938356d8396dc628535e5dd6f56.jpg
[PL_SQL Developer_PL_SQL Developer 11]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png2
[PL_SQL Developer 12]: https://imgsa.baidu.com/exp/w=500/sign=f42f3f7062600c33f079dec82a4d5134/5882b2b7d0a20cf4aee102bb7f094b36acaf9965.jpg
[PL_SQL Developer_PL_SQL Developer 12]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png3
[PL_SQL Developer 13]: https://imgsa.baidu.com/exp/w=500/sign=4383500506b30f24359aec03f895d192/8718367adab44aed16794580ba1c8701a18bfb9b.jpg
[PL_SQL Developer_PL_SQL Developer 13]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png4
[PL_SQL Developer 14]: https://imgsa.baidu.com/exp/w=500/sign=81cdb34adb1b0ef46ce8985eedc451a1/78310a55b319ebc4924a8dfd8b26cffc1e1716a7.jpg
[PL_SQL Developer_PL_SQL Developer 14]: /images/20220219/fb780f0a1bfb4c8bbefcd5280ab00d45.png5