oracle里面-->如果查看表结构或者视图详细结构？

[DiligencyMan]

如题

[watson110]

查询视图：
desc user_views;
--表同理
desc user_tables

[mantisXF]

GOOGLE ..
http://www.itpub.net/thread-119474-1-1.html
[Quote=引用楼主 DiligencyMan 的帖子:]
如题
[/Quote]

[icss_zhen]

在psql中的command窗体中
desc table_name;
或
view table_name;

[hebo2005]

DESC分数

[DiligencyMan]

自己看下！

[oraclelogan]

在plsql里面的command window下

select query from user_mviews where mview_name like '%free_sms_info_tab%';

desc free_sms_info_tab

[fuyou001]

查看看字段种其数据类型
select * from cols WHERE TABLE_name=upper('name')

[djs00717]

查看表结构
select * from USER_TAB_COLUMNS ;

查看视图名称及详细结构
select * from dba_views ;

[sleepzzzzz]

desc table_name;
desc view_name;

select * from USER_TAB_COLUMNS where table_name= 'TEST' ; 

[范佩西_11]

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';

[yier1013]

desc 表名
desc 视图名