Shulou(Shulou.com)05/31 Report--

This article mainly introduces Oracle how to view the table structure commands, the article is very detailed, has a certain reference value, interested friends must read it!

Get the table:

Select table_name from user_tables; / / current user's table select table_name from all_tables; / / all user's table select table_name from dba_tables / / including system table select table_name from dba_tables where owner=' user name 'user_tables: table_name,tablespace_name,last_analyzed, dba_tables: ower,table_name,tablespace_name,last_analyzed, all_tables: ower,table_name,tablespace_name,last_analyzed, all_objects: ower,object_name,subobject_name,object_id,created,last_ddl_time,timestamp,status, etc.

Get table fields:

Select * from user_tab_columns where Table_Name=' user Table'; select * from all_tab_columns where Table_Name=' user Table'; select * from dba_tab_columns where Table_Name=' user Table' User_tab_columns: table_name,column_name,data_type,data_length,data_precision,data_scale,nullable,column_id etc. All_tab_columns: ower,table_name,column_name,data_type,data_length,data_precision,data_scale,nullable,column_id et al. Dba_tab_columns: ower,table_name,column_name,data_type,data_length,data_precision,data_scale,nullable,column_id et al.

Get table comments:

Select * from user_tab_comments user_tab_comments:table_name,table_type,comments-correspondingly there are dba_tab_comments,all_tab_comments, which have more ower columns than user_tab_comments.

Get field comments:

Select * from user_col_comments user_col_comments:table_name,column_name,comments above are all the contents of this article entitled "how to View Table structure commands in Oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.