SQL> create table ttt(aaa number check(aaa>10));表已创建。已用时间: 00: 00: 00.01 SQL> select t.CONSTRAINT_NAME,tt.table_name,tt.column_name from user_CONSTRAINTS t, 2 user_cons_columns 3 tt where t.CONSTRAINT_NAME=tt.CONSTRAINT_NAME and tt.table_name='TTT' and column_name='AAA';CONSTRAINT_NAME TABLE_NAME ------------------------------ ------------------------------ COLUMN_NAME -------------------------------------------------------------------------------- SYS_C001266 TTT AAA 已用时间: 00: 00: 00.50 SQL>
SQL> alter table ttt drop constraints SYS_C001266;表已更改。已用时间: 00: 00: 00.80 SQL> select t.CONSTRAINT_NAME,tt.table_name,tt.column_name from user_CONSTRAINTS t, 2 user_cons_columns 3 tt where t.CONSTRAINT_NAME=tt.CONSTRAINT_NAME and tt.table_name='TTT' and column_name='AAA';未选定行已用时间: 00: 00: 00.10 SQL>
SQL> select t.CONSTRAINT_NAME,tt.table_name,tt.column_name from user_CONSTRAINTS t,
2 user_cons_columns
3 tt where t.CONSTRAINT_NAME=tt.CONSTRAINT_NAME and tt.table_name='TTT' and column_name='AAA';CONSTRAINT_NAME TABLE_NAME
------------------------------ ------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
SYS_C001266 TTT
AAA
已用时间: 00: 00: 00.50
SQL>
SQL> select t.CONSTRAINT_NAME,tt.table_name,tt.column_name from user_CONSTRAINTS t,
2 user_cons_columns
3 tt where t.CONSTRAINT_NAME=tt.CONSTRAINT_NAME and tt.table_name='TTT' and column_name='AAA';未选定行已用时间: 00: 00: 00.10
SQL>