Alter table to primary key and check it in user_ind_columns and user_cons_columns

  
SQL>
SQL> set echo off
SQL> create table emp(
  2           emp_id            integer
  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);

Index created.

SQL>
SQL> alter table emp add (constraint  pk_alter primary key(emp_id));

Table altered.

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

no rows selected

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

no rows selected

SQL>
SQL> drop table emp cascade constraints;

Table dropped.

Related examples in the same category

1.	Add Primary Key
2.	Use alter table to add foreign key with cascade delete
3.	Use alter table to add foreign key with cascade delete for more than one column
4.	Alter a table to insert primary key and index
5.	Add primary key and try to insert default value to it
6.	DUP_VAL_ON_INDEX exception.
7.	Alter table to add primary key
8.	Joined primary key
9.	Add primary key as the last statement
10.	Setting primary key as declaring the column

Alter table to primary key and check it in user_ind_columns and user_cons_columns : Add Primary Key « Constraints « Oracle PL / SQL

Related examples in the same category