查询ORACLE表的约束

违反约束条件无法删除, 查询约束关系slq如下:

select * from user_constraints where table_name='TB_DEVICE'
select * from user_constraints where constraint_name='PK_TB_DEVICE'

posted on 2009-05-13 23:55  寒云  阅读(336)  评论(0编辑  收藏  举报