how to create a primary key with out creating an index?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What is coalesce sql?
Explain the two type of Cursors ?
What is pl/sql table? Why it is used?
What are types of indexes in sql?
How does index help in query performance?
Can we insert data into view?
What is query execution plan in sql?
What is clustered index in sql?
What is meant by truncate in sql?
What are the different ddl commands in sql?
How long will it take to learn pl sql?
What is pseudo column ?