how to create a primary key with out creating an index?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / sudhir

9 Answers
20876 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to create a primary key with out creating an index?..

Answer / bhargavi

Primary key creates an Index implicitly.....so Its not
possible to create a Pk without am index....

Is This Answer Correct ?

16 Yes

0 No

how to create a primary key with out creating an index?..

Answer / vinoth

ALTER TABLE EMP ADD CONSTRAINT EMP_PK PRIMARY KEY(EMPNO)
DISABLE;

Primary key constraint is created and no index is created
since the constraint is disabled initially.

Is This Answer Correct ?

11 Yes

0 No

how to create a primary key with out creating an index?..

Answer / santanu

hi,
we can create pry key also by creating a sequence with NO
CYCLE option.
san

Is This Answer Correct ?

2 Yes

0 No

how to create a primary key with out creating an index?..

Answer / akshay

yes it possible using trigger
Create sequence S_Number
start with 1
increment by 1;

create trigger Pri_key before insert on table(C1)
for each row
Variable number(5);
begin
select sequence.nextvalue into Variable;
insert into table c1 value(variable);
end

Is This Answer Correct ?

3 Yes

2 No

how to create a primary key with out creating an index?..

Answer / anubha

The above trigger will give error of mutating table as in
this trigger you are doing dml operation on the triggering
table.

Is This Answer Correct ?

1 Yes

0 No

how to create a primary key with out creating an index?..

Answer / priyankur

Unique constraint will always create non-clustered index on
column. so creation of Unique constraint is not the
solution. Yes, only sequence can create unique column but
that is not necessarily Primary key unless you treat it
likewise.

Is This Answer Correct ?

0 Yes

0 No

how to create a primary key with out creating an index?..

Answer / highness

joseph please make it clear

Is This Answer Correct ?

1 Yes

2 No

how to create a primary key with out creating an index?..

Answer / benniyel gnanaraj

when u create a primary in the table the index is
implicitly create.index is not neccessary

Is This Answer Correct ?

0 Yes

1 No

how to create a primary key with out creating an index?..

Answer / joseph

useing the constraints

Is This Answer Correct ?

0 Yes

5 No

Post New Answer