select * from ALL_CONS_COLUMNS where owner = 'USER NAME'
select * from USER_tab_columns
--查看某用户索引 select * from ALL_INDEXES where owner = 'USER NAME';--查看某用户约束条件 select * from ALL_CONS_COLUMNS where owner = 'USER NAME';--查看某用户字段明细 select * from ALL_TAB_COLUMNS where owner = 'USER NAME';以上视图可以结合使用,不过使用前先确定登陆用户的权限.
where owner = 'USER NAME'
select * from ALL_INDEXES
where owner = 'USER NAME';--查看某用户约束条件
select * from ALL_CONS_COLUMNS
where owner = 'USER NAME';--查看某用户字段明细
select * from ALL_TAB_COLUMNS
where owner = 'USER NAME';以上视图可以结合使用,不过使用前先确定登陆用户的权限.
我用了sanoul朋友的方法,查到了!
select column_name from ALL_CONS_COLUMNS
where owner = 'USER NAME' and table_name='table name';
再次谢谢各位啦!