17,377
社区成员
发帖
与我相关
我的任务
分享
desc tablename或者用语句
select a.TABLE_NAME, a.COLUMN_NAME, b.comments,a.data_type
from user_tab_columns a, user_col_comments b
where a.TABLE_NAME = b.table_name
and a.COLUMN_NAME=b.column_name
and a.table_name='TABLENAME';
desc table_name;
desc view_name;
select * from USER_TAB_COLUMNS where table_name= 'TEST' ;
select query from user_mviews where mview_name like '%free_sms_info_tab%';
desc free_sms_info_tab
在psql中的command窗体中
desc table_name;
或
view table_name;