Common commands for viewing table structures in Oracle

Common commands for Oracle to view table structures to obtain tables: www.2cto.com select table_name from user_tables; // select table_name from all_tables for the current user's table; // select table_name from dba_tables for all users; // including the system table select table_name from dba_tables where owner = 'username' user_tables: table_name, tablespace_name, role, and other dba_tables: ower, table_name, tablespace_name, role, and other all_tables: ower, tablespace_name, last_analyzed, and other all_objects: ower, object_name, subobject_name, object_id, created, encrypted, timestamp, status, and other table fields: Explain select * from user_tab_columns where Table_Name = 'user table '; select * from all_tab_columns where Table_Name = 'user table'; select * from region where Table_Name = 'user table'; user_tab_columns: table_name, column_name, data_type, data_length, data_precision, data_scale, nullable,
Column_id all_tab_columns: ower, table_name, column_name, data_type, data_length, data_precision, data_scale, nullable,
Column_id and other dba_tab_columns: ower, table_name, column_name, data_type, data_length, data_precision, data_scale, nullable,
Column_id and so on to obtain Table comments: www.2cto.com select * from user_tab_comments: table_name, table_type, comments -- corresponding to dba_tab_comments, all_tab_comments, these two are compared
The ower column is added. Obtain field comments: select * from user_col_comments: table_name, column_name, comments