根据约束名称查询表明
SELECT
constraint_name,
constraint_type,
table_name
FROM
all_constraints
WHERE
CONSTRAINT_NAME = 'PK5_1_1_1_2_2_1';
查询唯一约束
SELECT
*
FROM
user_indexes
WHERE
index_name = 'PK5_1_1_1_2_2_1'
查询表中有那些约束
SELECT
CONSTRAINT_NAME,
CONSTRAINT_TYPE,
STATUS
FROM
USER_CONSTRAINTS
WHERE
TABLE_NAME = 'QCS_TEMPLETE';
删除唯一约束
ALTER TABLE QCS_TEMPLETE DROP CONSTRAINT PK5_1_1_1_2_2_1;