主键唯一约束oracle,【INDEX】Oracle中主键、唯一约束与唯一索引之区别

SQL>

alter table test drop constraint UK_TEST_TNAME;

Table

altered.

SQL>

alter table test drop constraint UK_TEST_TID;

Table

altered.

SQL>

select table_name,column_name,constraint_name from user_cons_columns where

table_name=upper('test');

TABLE_NAME      COLUMN_NAME     CONSTRAINT_NAME

---------------

--------------- --------------------

TEST            TNO             PK_TEST_TNO

SQL>

select table_name,column_name,index_name from user_ind_columns where

table_name=upper('test');

TABLE_NAME      COLUMN_NAME     INDEX_NAME

---------------

--------------- ------------------------------

TEST            TNO             PK_TEST_TNO

TEST            TID             IDX_TEST_TID