Oracle Common view Table structure commands

Original: Oracle Common view table Structure command

Get table:

Select table_name from User_tables; The current user's table

Select table_name from All_tables; All users ' tables

Select table_name from Dba_tables; including system tables

Select table_name from dba_tables where owner= ' user name '

User_tables:

Table_name,tablespace_name,last_analyzed, etc.

Dba_tables:

Ower,table_name,tablespace_name,last_analyzed, etc.

All_tables:

Ower,table_name,tablespace_name,last_analyzed, etc.

All_objects:

Ower,object_name,subobject_name,object_id,created,last_ddl_time,timestamp,status, etc.

Get table field:

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, etc.

Dba_tab_columns:

OWER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE,COLUMN_ID, etc.

Get Table Comments:

SELECT * FROM User_tab_comments

User_tab_comments:table_name,table_type,comments

There are also dba_tab_comments,all_tab_comments, the two more than User_tab_comments ower column.

get field Comments:

SELECT * FROM User_col_comments

User_col_comments:table_name,column_name,comments

Oracle Common view Table structure commands