Create unique index and check it in user_ind_columns and user_cons_columns : Create Index « Index « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Index
3. Create Index

SQL>
SQL> set echo off
SQL> create table emp(
  2           emp_id            integer     primary key
  3          ,lastname               varchar2(20)    constraint lastname_create_nn not null
  4          ,firstname              varchar2(15)    constraint firstname_create_nn not null
  5          ,midinit                varchar2(1)
  6          ,street                 varchar2(30)
  7          ,city                   varchar2(20)
  8          ,state                  varchar2(2)
  9          ,zip                    varchar2(5)
 10          ,shortZipCode           varchar2(4)
 11          ,area_code              varchar2(3)
 12          ,phone                  varchar2(8)
 13          ,company_name           varchar2(50));

Table created.

SQL>
SQL> create unique index pk_idx on emp (emp_id);

SQL>
SQL> select index_name, table_name, column_name from user_ind_columns where table_name = 'EMP';


SQL>
SQL> select constraint_name, table_name, column_name from user_cons_columns where table_name = 'EMP';

SQL>
SQL>
SQL> drop table emp cascade constraints;

Table dropped.

SQL>