|
SQL>
SQL> create table movie(
2 movie_no integer constraint movie_pk primary key using index (create index movie_pk_idx on movie(movie_no) )
3 ,title varchar2(40)
4 ,rating char(4)
5 ,type varchar2(20)
6 ,star varchar2(40)
7 ,qty number
8 ,price number
9 );
Table created.
SQL>
SQL> select index_name, table_name, column_name from user_ind_columns where table_name = 'MOVIE';
MOVIE_PK_IDX MOVIE
MOVIE_NO
1 row selected.
SQL>
SQL> select constraint_name, table_name, column_name from user_cons_columns where table_name = 'MOVIE';
MOVIE_PK MOVIE
MOVIE_NO
1 row selected.
SQL>
SQL> drop table movie cascade constraints;
Table dropped.
|